LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to measurtement file with comma as decimal point?

Hi. I'm using Wirte to measurement file to store waveform data. As I undertand it, it should store data with the same decimal point as the operating system is using. I'm using comma as decimal point. In labview the data is shown with comma, but in my stored data it is a period. I want to be able to do some work on this data in excel, but excel uses comma as decimal point. How do I store the data with comma as decimal point?
0 Kudos
Message 1 of 3
(3,974 Views)

Hi! I’m not sure if there is a way of saving data with comma as decimal point using Write to measurement file. However, you should be able to import the data into Excel correctly. When you open an lvm file in Excel, a Text Import Wizard appears. In the third step of this wizard there is an advanced button. If you press it and change the decimal separator from comma to period, you will be able to read the data correctly.

Regards

Øyvind Ø

0 Kudos
Message 2 of 3
(3,953 Views)
The LVM format specifically uses a period as the decimal separator to prevent problems with commas being used as the field separator (CSV format).  There is currently no way to change this.  However, there is an easy workaround.  Open the LVM file in a text editor and replace all the periods with commas.  You will get some punctuation problems in long text fields, but this should be minimal.
0 Kudos
Message 3 of 3
(3,939 Views)