Import Multiple Columns from a Delimited File

[Joseph Jankowski]

Sirs,

I am working on trying to import a calibration data file for a sensor.  I would like to interpolate the data as I recieve it from my DAQ (Agilent).  In order to do this, I would like to read in a tab delimited file, and run the Interpolate VI.  However, when I run the Read from SpreadSheet VI without any input wiring, I select the data file, and output to an array, I am only able to import the first column of data.  Is there another way to do this, or have I forgot to set a parameter? 

Please advise

Thanks,

Joseph Jankowski

[AndrewAlford]

There are two array outputs from the Read Spreadsheet VI, If you want more than one column you need to connect to the 2D array output.

[Joseph Jankowski]

Unfortunately I have connected to the 2-D output.  Under this output, I am still only getting the single column output.

I also tried to use the format string to array function, and this also only produced one column.

Thanks,

Joe

[Dennis_Knutson]

Is the data all numerics and is the delimiter truly a tab? Can you post a segment of the file you're trying to read?

[AndrewAlford]

If you are attached to the 2-D array then there is an issue with the format of the file you are trying to import. What is the file type of the calibration file. If you could provide an example that would help.

[Joseph Jankowski]

Problem Solved.

Although the files appeared to be tab delimited, they were not.

I replaced the spaces with Tabs, and the import worked well, using both methods.

Thanks All,

Joe