string format problem using read from spreadsheet file.vi

[detech]

I try to read csv file using read from spreadsheet file.vi. I do not know how to set the right string format to show "all rows" the same as "string read from file". I guess, the first col number is too big, and col2 col 3 has too small numerical data. Please help

[Dennis_Knutson]

If you want to read 9 significant digits, just use the %.9f format string. Your %9.9f format string says to only process the first nine characters in the field so you aren't getting the exponent. You can also change the format and precision of the front array display to something else (i.e. scientific) to display both the large and small numbers. Just right click on a numeric indicator in the array and select Properties and then click the Format and Precision tab.

[JaredA]

It looks like you have just about everything correct. The last answer was a good point, pointing out your format string syntax. If you are not familiar with how to format strings, you should take a look at this topic in under LabVIEW Help > VI, Function, and How-To Help.

I was able to get your application to work by changing the digits of precision on the front panel array. Try increasing that number and you should have your expected results.