Using the same format like Excel

[RavensFan]

test.txt is what I have.  I used the carriage return line feed.  Your file show just carriage returns and double carriage returns.  I don't know why.

I would not trust the "HTML interpreter".  Open it in notepad.  Open it in Labview and send to a string indicator.  Be careful about the convert EOL option on the Read Text File VI as that could confuse the results.

Message Edited by Ravens Fan on 12-16-2007 03:13 PM

[J.Dred]

nearly finished 😉 check my text file, only 1 thing is problematic now.

raven , in your version you have 3.454 , in my code it is 3,454 , I need it also as (three point five four five) i have with commas , so excel interprets it wrong!

why you have points and I have commas ?

regards

[RavensFan]

That is what I was saying earlier about your international region settings in MS windows.  If you go to control panel, there is an applet for Regional and Language Options.  It must be set to comma there in order to get the comma.

To get a period, you have two choices.

1.  Go to that control panel setting and set the decimal separator to period.

2.  In the format string, in your VI, make it     %.;%.03f,%.03f,%.03f,%.06   

That %.;  (percent, period, semicolon) will override the Windows setting and force the decimal separator to period.