Saved data in text file doesn´t show decimal places

[Jugo]

Hey there!

I feel like i am posting quite a lot of questions but i am a complete amateur in LabVIEW and not a programmer so this is the place to go for me..

Anyways, i am sending data from my arduino board to LabVIEW and the values of my sensors are shown correctly on my front panel, BUT in my text file the decimal places are missing.

As you can see here, the values are complete, but in the following image you see that the decimal places in my text file are missing

I personally think, that the problem is with the way my values are written. In arduino comes first a point " . " and then the decimal places. For example "12.34". But LabVIEW recognizes as seperation sign only a comma " , ". So for the decimal places to show in my text file, the values have to look like this "12,34". But yeah that is not the case and also not possible. 

Does my theory make sense and more importantly, how can i fix this? Because i can not change the way arduino displays the data.

Thanks for any help!😊

 

[crossrulz · Accepted solution]

It is coming from a system setting in your OS.  You apparently live in a region where the comma is used as the decimal separator instead of a period.  Use "%.;%f" for your format at the Array To Spreadsheet String.  The "%.;" part forces the node to use the period for the decimal separator.

EDIT: You should do the same thing for your Spreadsheet String To Array.

[JÞB]

You can specify the radix separator in your format strings. LabVIEW defaults to the OS localized setting but %: and %; can be used to override that default. Check the format specifiers section in the help file

[Jugo]

Hey man 😊

yeah i changed it and it works perfectly!!!😁

 

Thank you so much i really appreciate it!