I have 1 gz file in URL like http://<<domainName>>/testCSV.txt.gz
how to read it from JMP
gzblob = loadtextfile("https://drawoutside.com/example.txt.gz",blob()); blob = gzipuncompress(gzblob); // one way... text = blobtochar(blob); show(text); // another dt = open(blob,"text");
its able to open file however it showing only first line of file. bt If we unzip manually that file and open we can see data.
We'll need more information.
... show(length(gzblob)); blob = gzipuncompress(gzblob); show(length(blob)); show(left(char(blob),2000)); ...
The goal of the 2000 is to see enough of the first and second line of data to understand what is truncating the file. I'll guess there is a null byte between the lines, and the last show(...) will display it.
Yes, actually that GZ file itself is CSV each row separated by next line
