pull data from 'write to spreadsheet file'

[hiNI]

Hello,

Attached is a file that I wrote data to from one of my programs.  (The file can be opened with wordpad for proper viewing).   The 1st column contains frequencies, the second column contains corresponding tuned data.  I would like to extract the first three frequencies and corresponding tuned data, to be put in an array that will be used for further sweeps.  Bascially, I would take the first three frequencies:  794, 809 and 824, put that data in an array.  Then in my first sweep with the frequency of 794, call the corresponding tuned value of 0.2078 to be used in the sweep, then for the 809 sweep, call the corresponding tuned value of 0.2126 and so on. 

Your help will be greatly appreciated.

Thanks,

Rajesh.

[pacific]

Hello Rajesh,

The attached VI reads the data from the file and also indexes the first three rows.
Hope this helps.

Prashant.

[hiNI]

Hello,

How can I scan the string and extract the value associated with a specific frequency?  For example, say that I wanted to analyze 741, the associated value is 0.2078.  How can I extract that specific value?

Thanks,

Rajesh.

[Dennis_Knutson]

A basic function in LabVIEW is the For loop that will auto-index an array. The simple VI below shows how to extract the frequency and associated value for each row.