read specific entries from spreadsheet

[rbinghay]

Heres the prob: I have tab delimited files. Basically there are 4 columns: 1st is time, 2nd is Xaxis accel, 3rd is Yaxis accel and so on. The whole file can go up to 120 odd seconds @ 10000Hz, i want to graph the whole thing so I can do analysis on the whole file. But the problem is, it is divided into sections of 2000 samples, ie 0.2 seconds. every 0.2 seconds there is a set of headings:

Channels 3   
Samples 2000 2000 2000 
Date 2006/09/11 2006/09/11 2006/09/11 
Time 11:44:24.405999 11:44:24.405999 11:44:24.405999 
Y_Unit_Label g g g 
X_Dimension Time Time Time 
X0 7.9999999999999993E-1 7.9999999999999993E-1 7.9999999999999993E-1 
Delta_X 0.000100 0.000100 0.000100 
***End_of_Header***    
X_Value Acceleration0 Acceleration2 Acceleration3 Comment

It is possible to go into notepad and manually delete the headings and use read from spreadsheet file.vi but there has to be a better way as doing so is so tedious? I tried using delete from array but I need to some how loop which rows i want deleted.

Attached is my VI:

Thanks

[F._Schubert]

Many ways to solve this problem, here is just a quick and dirty way:

All readings will give you a 0 in several columns when you parse a header string as spreadsheet. So just get rid of all rows where column n is 0.

If you have time and are going deeper into LabVIEW, get the OpenG-stuff, there is some VIs that might help you.  But coding it on your ownwould propably take less effot for now.

Felix

[Cory_K]

Do the headings have any regular pattern?

If so, you can iterate through each row, using a for loop.

If row == regular pattern, do nothing.

If row != regular pattern, add to data array.