Read a compressed ascii data file?

Question

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.. http://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

Szabolcs · Accepted Answer · 2015-04-21T14:51:29.630

3

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.

Just use

Import["data.lvm", "XLSX"]

Note: Office Open XML files are actually just ZIP files with a standardized directory structure with XML files inside. This is why you can unzip it.

edited Apr 21 '15 at 14:51

answered Apr 21 '15 at 14:39

Szabolcs

234,956
30
623
1,263

possibly someone saved the file in excel and then gave it the wrong extension. – george2079 Apr 21 '15 at 16:37
@Szabolcs Thanks, this is indeed the case. After your insights, I found this answer helpful for importing the data in a more convenient form. – dionys Apr 22 '15 at 14:29

Read a compressed ascii data file?

1 Answers1