open csv file in labview

[hussey]

hello

its little difficult for me to open .csv file in labview. so can any one suggest labview program or any hint for attached file bellow?

its really a challange to open it in Labview.

if free then try to solve this issue.

thanks

[crossrulz · Accepted solution]

Use the Read Spreadsheet File.  You could then use Index Array to get the first colum and do a search for an empty string.  That will give you the break between the header data and the actual data.  Take all of the data after that line and convert it to a number (String to Floating/Exp Number).

[hussey]

sorry that way not working i had tried

[crossrulz]

Then show us what you tried.  There is likely just a stupid mistake in there that you missed.

[hussey · Accepted solution]

its worked only there is a problem in delete some index

[hussey]

there are six column but i am able to read only first column data .

what to do for read 4 th column.

same process doesn't work.

thanks

[hussey]

please find attached vi.

[crossrulz]

You need to set your delimiter to be a comma.  The default for the Read Spreadsheet File is a tab.

And why are you using Delete From Array?  Why not Index Array?

And I noticed there is an extra comma in your data so you will get a colum of just 0s.

Here's what I was saying to do.

[hussey]

hello

thaks a lot for your valuable response.

i agreed that you are genius.

thanks