# Read a compressed ascii data file?

I would like to write a filter for Import to handle data files that are generated by LabView in the LVM format. This should be straightforward, since the format is supposed to consist of comma delimited ASCII text. However, if I read the file in normally, I get junk with a few legible snippets mixed in.

The file can be opened directly in MS Excel, so my guess is that the ASCII data is compressed and being unzipped transparently when it is opened in that program.

BinaryReadList["data.lvm", "Character8"]

(* Large output: {P,K,\.03,\.04 ... *)


I've posted the output of BinaryReadList here. The original data file can be downloaded here.

Are there any facilities available in Mathematica to deal with this kind of data?

• the lvm format itself is not compressed. do you know the history of the file? can you make it available? – george2079 Apr 21 '15 at 12:00
• @george2079 The first few characters look like the magic numbers for a zip file to me: "PK\003\004" – dionys Apr 21 '15 at 12:23
• see what this does.. reference.wolfram.com/language/ref/ExtractArchive.html – george2079 Apr 21 '15 at 13:29
• @george2079 Interesting: ExtractArchive gives me a 4 folders (xl, NI, docProps, and _rels) containing XML files. – dionys Apr 21 '15 at 13:37

This is a standard Excel XLSX file. It is not a compressed ASCII file. I don't know why LabView uses the lvm extension, it seems weird. But then I don't know anything about LabView.
Import["data.lvm", "XLSX"]