BookmarkSubscribe
Choose Language Hide Translation Bar
poweruser87
Community Trekker

Can JMP open .zip archive contents?

Hello,

I have a .zip archive with some tab delimited data saved as text files inside.  I am wondering if there is a way JMP can open one of these text files as a data table directly from the .zip file.  Based on the documentation I'm reading it sounds like this might be possible:

http://www.jmp.com/support/help/Utility_Functions.shtml  --> see Open() and the Zip arg

http://www.jmp.com/support/help/Other_Objects.shtml#1931138

For some reason I cannot figure out the syntax for this, does anyone know more?

I have a path to the .zip file on my local pc and a name of one of the text files I would like to import.  For sake of example let's call them:

path = C:\ZipArchive

file = test1.txt

Any help would be greatly appreciated.  Thank you.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
pmroz
Super User

Re: Can JMP open .zip archive contents?

I got some code from Peter W a while back that will do what you want.  To make this work, save a few text file datasets (e.g. csv format) into Big Class.zip.  Then run the following code:

zipdt = open("c:\temp\Big Class.zip", Zip);

zip_member_list = zipdt << dir;

// Open each member file

for (i = 1, i <= nitems(zip_member_list), i++,

      zip_file = zipdt << read(zip_member_list[i], format(blob));

// Open the file

      dt = open(zip_file, text);

);

2 REPLIES 2
Highlighted
pmroz
Super User

Re: Can JMP open .zip archive contents?

I got some code from Peter W a while back that will do what you want.  To make this work, save a few text file datasets (e.g. csv format) into Big Class.zip.  Then run the following code:

zipdt = open("c:\temp\Big Class.zip", Zip);

zip_member_list = zipdt << dir;

// Open each member file

for (i = 1, i <= nitems(zip_member_list), i++,

      zip_file = zipdt << read(zip_member_list[i], format(blob));

// Open the file

      dt = open(zip_file, text);

);

poweruser87
Community Trekker

Re: Can JMP open .zip archive contents?

Works great.  Thanks!

0 Kudos