Read spreadsheet file with text delimiter

[Gepponline]

Hi!,

   I have a problem with a spreadsheet file.

I need to import a tabulated file that contain some text fileds with a EOL inside.
I've tried exporting that file in csv with a text delimiter such as " but the problem is how to import the file makin labview recognize the text field and so ignore the EOL in the text field.

At the moment with normal spreadsheet VI's i get a new line when i have a text field with an EOL character.

Is there any solution for my problem?

 

 

EXAMPLE:

88 250 P A2 1971 1-lug-1990 Tenax D 250 P DP "Testa con passaggio acqua

Monta Verin D. 60 corsa lunga" 110 x 110 345 Tenax 1

 

the above text return me two line 'cause "Testa con passaggio acqua EOL Monta Verin D. 60 corsa lunga" is a single text field and the EOL must be ignored.

 

thank you!

 

Geppo!

[JKSH]

Hi,

 

You can manually search for tabs yourself to split the text into separate strings.

 

If you install OpenG, you'll get the "String to 1D Array" VI that is designed for your use case.

[Porter]

I wrote Robust CSV for this purpose: http://lavag.org/files/file/239-robust-csv/

 

Just specify the delimiter as Tab.