cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
shasha_2
Level III

JSL code: convert jmp file to csv file

Hi, I am trying to convert JMP file into csv file. It converts the file into csv, but I had a doubt. Is there a way to convert two file into two different csv files at once where both the file paths are given. Here is my code where I am able to save dt as csv but I don't know how to save dt1 as csv file :

dt = Open("$SAMPLE_DATA/big class.jmp");
dt1 = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) );
Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) );
dt << save( "$Desktop/bigclassdemo.csv" );
Eval( Parse( "pref(" || current_pref || ")" ) );
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: JSL code: convert jmp file to csv file

Just point to the dt1 data table reference

dt = Open("$SAMPLE_DATA/big class.jmp");
dt1 = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) );
Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) );
dt << save( "$Desktop/bigclassdemo.csv" );
dt1 << save( "$Desktop/semiconductorcapabilitydemo.csv" );
Eval( Parse( "pref(" || current_pref || ")" ) );
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: JSL code: convert jmp file to csv file

Just point to the dt1 data table reference

dt = Open("$SAMPLE_DATA/big class.jmp");
dt1 = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) );
Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) );
dt << save( "$Desktop/bigclassdemo.csv" );
dt1 << save( "$Desktop/semiconductorcapabilitydemo.csv" );
Eval( Parse( "pref(" || current_pref || ")" ) );
Jim