topic how to save .csv and zip/compress the csv file with jsl in Discussions

how to save .csv and zip/compress the csv file with jsl

robust1972 — Wed, 28 Sep 2016 13:42:16 GMT

hi, all

anyone know how to save .csv and zip/compress the csv file with jsl? Is it possible at all?

thanks!

Evan

Craige_Hales — Wed, 28 Sep 2016 15:24:56 GMT

dt = Open( "$sample_data/big class.jmp" );

dt << save( "$temp/deleteme.csv" ); // create a temporary CSV

csvtxt = Load Text File( "$temp/deleteme.csv" ); // and load it as text

ziparchive = Open( "$temp/deleteme.zip", "zip" ); // open a new or existing ZIP

Show( ziparchive << dir ); // old members

actualname = ziparchive << Write( "bigclass.csv", csvtxt ); // add new member

Show( ziparchive << dir ); // the new name may change if conflict

restore = ziparchive << read( actualname, Format( blob ) ); // read the new member

path = Save Text File( "$temp/deleteme2.csv", restore ); // put back on disk

Open( path ); // finish the round-trip by opening

Craige_Hales — Wed, 28 Sep 2016 18:17:37 GMT

the last two lines can be simplified:

open(restore,"text");

The blob data from the ziparchive object can be opened directly with the "text" argument.

Craige_Hales — Wed, 09 Nov 2016 10:07:56 GMT

More about JMP's zipArchive object: Load Compressed Data