Support Forums
Logged data digits

Hello,

Have a question regarding logged data.
If I look at the csv file then it seems that sometimes data is shown with different numbers of digits in the same column while the real value does not change.

Please have a look at the attached document. For example the MS Battery Voltage column. Sometimes the data is shown with 5 digits then with 8 digits. While the sampled real value does not change.

5cb309ef51f36

Any idea's how to prevent this?

Hello, Have a question regarding logged data. If I look at the csv file then it seems that sometimes data is shown with different numbers of digits in the same column while the real value does not change. Please have a look at the attached document. For example the MS Battery Voltage column. Sometimes the data is shown with 5 digits then with 8 digits. While the sampled real value does not change. ![5cb309ef51f36](serve/attachment&path=5cb309ef51f36) Any idea's how to prevent this?

Hi Msmax,

Could you send me the csv file? I am assuming you use a comma for decimal point character.
The maximum digit in a number is 8, if you have a number with 2 digit then obviously you can get up to 6 decimal points.
A number with 3 digit will allow you to have 5 decimal points as so on

However if there is 0 at the end of decimal points then it will be discarded.
Therefore you can see different digit number in the data.

Best regards,
Rudy Gunawan

Hi Msmax, Could you send me the csv file? I am assuming you use a comma for decimal point character. The maximum digit in a number is 8, if you have a number with 2 digit then obviously you can get up to 6 decimal points. A number with 3 digit will allow you to have 5 decimal points as so on However if there is 0 at the end of decimal points then it will be discarded. Therefore you can see different digit number in the data. Best regards, Rudy Gunawan

Hello Rudy,

Guess you are right. So that means that Excel is discarding the zero's but they are still in the log?
Changing the comma to a dot as decimal point char in Excel will solve this then?
How ever in NL we use the comma as per standard for decimal point char.

How to handle this the best way?
Check the screenshot:

5cb30b5831456

Hello Rudy, Guess you are right. So that means that Excel is discarding the zero's but they are still in the log? Changing the comma to a dot as decimal point char in Excel will solve this then? How ever in NL we use the comma as per standard for decimal point char. How to handle this the best way? Check the screenshot: ![5cb30b5831456](serve/attachment&path=5cb30b5831456)

Hi Msmax,

Unfortunately even in dataTaker, it discard the extra 0.

Changing a comma to a dot will not solve the displaying issue in Excel.
You can keep comma setting in dataTaker.
When dataTaker is using a comma as decimal point separator, it will use semicolon as data separator.

In this case, you must set your Excel system separator: decimal separator to a comma and thousand separator into a dot.
If your thousand separator is still a comma, you will see incorrect display.

Best regards,
Rudy Gunawan

Hi Msmax, Unfortunately even in dataTaker, it discard the extra 0. Changing a comma to a dot will not solve the displaying issue in Excel. You can keep comma setting in dataTaker. When dataTaker is using a comma as decimal point separator, it will use semicolon as data separator. In this case, you must set your Excel system separator: decimal separator to a comma and thousand separator into a dot. If your thousand separator is still a comma, you will see incorrect display. Best regards, Rudy Gunawan
22
4
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft