12-19-2017 03:40 AM
Hi everyone!!! Need a help! I can't understand why when i make array from spreadsheet string (photo in atachment) result is integer??? When i wrote that string format is %f %5,18f %d....actually i tried all combinations!!!! How can i got result like in strings help.
Delimetr is enter.
Thanks!!!!
12-19-2017 04:04 AM - edited 12-19-2017 04:05 AM
Hi teslo,
I can't understand why when i make array from spreadsheet string (photo in atachment) result is integer???
Usually this happens when you use OS settings with different decimal delimiter like German OS settings. Here the OS uses the comma instead of a point: LabVIEW doesn't understand to convert "4.99" correctly in this case.
When i wrote that string format is %f %5,18f %d....actually i tried all combinations!!!! How can i got result like in strings help.
Did you read the LabVIEW help for SpreadsheetStringToArray?
Did you follow the link for the format string explanations?
Did you go through that list showing all kind of format strings?
Did you notice the format string "%.;" and did you read its meaning?
RTFM!
Try "%.;%f" as format string!
12-19-2017 04:50 AM
Yes, i did it all, but nothing....
Mb it's real OS, do you know how i can eliminate it?
12-19-2017 04:55 AM
Hi teslo,
why don't you attach a VI with your example data? We cannot debog or improve images with LabVIEW…
Mb it's real OS, do you know how i can eliminate it?
What means "Mb"? What is a "real OS"? What do you want to eliminate? Do you want to "eliminate the OS"?
12-19-2017 05:48 AM - edited 12-19-2017 05:54 AM
The resulting output is determined by the wired input. If you want integers, the format string needs to be correct, but you also need to wire an array of integers as input. If you have an array of floats wired to it, right click the constant in the array and change the representation to integer. Never mind, got it the wrong way around. %,; or %.; should fix it.
12-20-2017 04:40 AM
"%.;.%10F" it helped me. Thanks))))
12-21-2017 07:48 AM
As the starter of the thread, you have the honer, power and responsebility to select a solution! I think GerdW hit the nail (the 10 for scanning from string is not needed), so please consider marking his answer as solution. Some of us (champions) can do that, but it's really something you should do. It helps others (searching and answering) to make sense of the forum. Thanks in advance.