From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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,471 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,467 Views)

like this ...

Spoiler
Example_VI.png

 

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