read from Spreadsheet File VI

[DavideTagliabue]

Hello to everyone!

I want to read a spreadsheet file VI, wich contain many rows with this format:

0.475009,0.242797;
0.023044,0.522105;
0.735105,0.634358;
0.955100,0.982586;

etc..

The goal is to divide these rows into 2 array: the first one contains the left number:

0.475009
0.023044
0.735105
0.955100

while the right one contains the right number:

0.242797

0.522105
0.634358
0.982586
Someone can help me?

Thanks and

Best regards!

 

[GerdW]

Hi Davide,

do you think you can make your way starting from this snippet?

It's rather unusual to have a different delimiter to denote EOL. You should use a comma only between numbers and get rid of the semicolon at EOL!

[DavideTagliabue]

Hi GerdW.

The end of line delimiter is ;

with comma i separate two different measurements: the left numbers rapresent a current measure, while the right numbers a voltage measure.

I want to read my csv file, split the numbers into two different array, then plot the current and the voltage.

My start point is:

where all rows are like this:

i want to separate the left numbers and the right numbers into two array

Best regards

[GerdW]

Hi Davide,

1. You need to give the separator char between your numbers, not the EOL char: change your string constant from semicolon to comma!

2. From your description I still think the semicolon is useless as you (probably) have some real EOL chars in your text file (CR, LF, or combination of both)!

[daveTW]

3. And you should change the type of the "Read from Spreadsheet File"- VI to Dbl, then it should ignore the semicolon and gives back the datatype you need.

[DavideTagliabue]

Resolved!

Thanks a lot!

Best regards

[GerdW]

Hi Davide,

usually the OP also tells how a problem was solved, to help others experiencing the same (or very similar) problem…