https://community.jmp.com/t5/Discussions/Methods-for-compressing-a-CSV-or-TSV-file-with-jmp-compression/m-p/556364#M77031 <P>I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this:</P><P>&nbsp;</P><PRE><CODE class=" language-jsl">MyDataFile = open(filename,Private); MyDataFile &lt;&lt; Compress File When Saved; MyDataFile &lt;&lt; save(filetosave);</CODE></PRE><P>This does work but has a very high memory demand since I have to open the file first. I have also tried using gzip compression on the text files when they are generated and then using GZIPUnCompress() in JMP14 and opening the file. I have not been able to figure out a way to open an externally gzipped file directly without having to unzip it, but I am under the impression that the compression jmp uses is also gz, so I am hoping there is a better way to handle this, such that I could either compress the files in jmp format more efficiently or ideally open a .csv.gz, .tsv.gz, .tab.gz etc. file type in JMP through a JSL code.</P> Fri, 09 Jun 2023 16:00:17 GMT CurbStegosaurus 2023-06-09T16:00:17Z https://community.jmp.com/t5/Discussions/Methods-for-compressing-a-CSV-or-TSV-file-with-jmp-compression/m-p/556364#M77031 <P>I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this:</P><P>&nbsp;</P><PRE><CODE class=" language-jsl">MyDataFile = open(filename,Private); MyDataFile &lt;&lt; Compress File When Saved; MyDataFile &lt;&lt; save(filetosave);</CODE></PRE><P>This does work but has a very high memory demand since I have to open the file first. I have also tried using gzip compression on the text files when they are generated and then using GZIPUnCompress() in JMP14 and opening the file. I have not been able to figure out a way to open an externally gzipped file directly without having to unzip it, but I am under the impression that the compression jmp uses is also gz, so I am hoping there is a better way to handle this, such that I could either compress the files in jmp format more efficiently or ideally open a .csv.gz, .tsv.gz, .tab.gz etc. file type in JMP through a JSL code.</P> Fri, 09 Jun 2023 16:00:17 GMT https://community.jmp.com/t5/Discussions/Methods-for-compressing-a-CSV-or-TSV-file-with-jmp-compression/m-p/556364#M77031 CurbStegosaurus 2023-06-09T16:00:17Z