LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I extract a particular column from a csv file?

I am using Read from Spreadsheet File.vi. My excel sheet is organized in comma delimited form as follows:

 

animal 1 data point 1, animal 2 data point 1, animal 3 data point 1

animal 1 data point 2, animal 2 data point 2, animal 3 data point 2

animal 1 data point 3, animal 2 data point 3, animal 3 data point 3

 

After being read in, the data are plotted on a mixed signal plot. The plot shows 3 waveforms; one for each animal. However, I would like to have a separate plot for each animal rather than having them all together. Is there a way to do this easily in Labview? I am relatively new to Labview, so any help is appreciated.

0 Kudos
Message 1 of 3
(2,585 Views)

Read From Spreadsheet File.vi will import the data as a 2D array.

 

Simply use the Index Array vi to extract the columns you want.  

0 Kudos
Message 2 of 3
(2,581 Views)

like this ...

Spoiler
Example_VI.png

 

0 Kudos
Message 3 of 3
(2,576 Views)