Doing sample compression to a already generated .lvm file

[Bhavinshah]

I captured huge amount of data into *.lvm file . I want to take it to spreadsheet but the data is too huge to fit into a spreadsheet. actually I forgot to use a sample compression in the VI. so how can I open the LVM file and do sample compression and then take the reduced dataset to excel?

[David_L]

Probably the best idea is to just create a new VI that will read the LVM file, parse out whatever data you don't want, and then write it to another LVM file.  Fast easy and gets the job done.

[Bhavinshah]

Hi

Thanks for the prompt reply

I am new to Labview

Do you know if there is such VI designed by somone that I cna use.

Coz when I tried there were some complecated thing like converting the text into values and then only I can compress the data

Thanks once again

Bhavin

shah

[David_L · Accepted solution]

I was thinking something as simple as this:

Just read the lvm, decimate the array to purge unneccesary samples and then write it back to another text file. 

[Bhavinshah]

Thanks a lot, problem solved

Bhavin Shah 

[lokisspydr]

If I am reading the description for this this will only help if you are decimating in one dimension. I have and LVM that (again the rate function was not corrected)  I have 1.6k points for 15 seconds for 8 segments with 3 columns of data. I would like to compress it to 20 points per second. Any suggestions?

Thanks

[DFGray]

You can do the same thing for each column of the LVM file, assuming that sort of decimation is OK.  That will depend on your data and what you need from it.  If you can just throw away data, you may want to consider averaging, instead.  Also, the above example loses any timestamp information.  If you want to retain this (assuming it exists), convert the DDT to an array of waveforms instead of a single Y array (or 2D array), decimate the Y components of the waveforms, rewrite the Y back into the original waveform, then save to LVM.  This is pretty easy to do with a FOR loop modification to the above code.