Problem converting existing data from file into graph

[Lesmouch]

Hello,

I'm kind of new to Labview programming and I have a question regarding extracting information from a file. 

I have 20 sensors that saves 20 data at all 15min.  The results are saves this way, where the 01-20 are the different sensor and the two other column are data.  Is there a way to display the results for each sensoron a long time scale?

Here is the raw data that I have:

2007-12-21 9:52 AM
01  00000 04437
02  00000 05860
03  00000 05215
04  00000 01921
05  00000 02871
06  00000 01018
07  00000 01909
08  00000 02931
09  00000 05781
10  00000 02378
11  00000 04518
12  00000 03853
13  65535 00000
14  00000 02632
15  00000 07900
16  00000 03934
17  00000 00896
18  00000 01168
19  00000 02791
20  00000 05547

2007-12-21 9:52 AM
01  00000 04401
02  00000 05828
03  00000 05177
04  00000 01909
05  00000 02913
06  00000 01006
07  00000 01892
08  00000 02916
09  00000 05768
10  00000 02363
11  00000 04493
12  00000 03837
13  65535 00000
14  00000 02617
15  00000 07854
16  00000 03916
17  00000 00889
18  00000 01185
19  00000 02811
20  00000 05593

Thanks,

Felix

[johnsold]

Felix,

There is no pre-programmed way you convert your data to the graphs you want, but it should not be too difficult to program. A few questions first about the data format.

1. The sample you posted has the same time for both datasets. How do you want to handle the time axis? Is it assumed that each dataset is equally spaced in time from the previous one or is the time in the file important to the position on the display axis? How do you handle identical timestamps?

2. Are the last two columns separate data values or do they get combined in some way? I ask because the first of the columns is always 0 except for sensor 13.

3. If they represent separate data values, do they get plotted on different graphs?

4. What kinds of delimiters are used in the file? Spaces, tabs, other? Line separators? Do the date-time fields use the same delimiters?

The string conversion or formatting functions and possibly the Read from Spreadsheet file functions are the ones you will likely use.

Lynn

[Lesmouch]

Lynn,

Sorry, you're right, the example I posted has the same timesets, it was a 'setting up run'.  In fact its not supposed to be a problem because the sampling is supposed to be at 15min.

The last two columns are the same sensor but are not combined.  The sensor 13 use to have a problem, it's working good now!

Basically, I most interesed in the sensor number and the last column, the center column is not really needed.

I thnik the guy who did that code use tab to separate the sensor from the first data colum and space to seperate the second data column from the third.  The timestamp is from Labview Get date/time function.

How would you proceed?

Thanks

Félix.