Question

CSV import and decimal separators

  • 12 December 2023
  • 5 replies
  • 94 views

Userlevel 2
Badge +4

Hi,

We have a csv file with semicolon seperated data.
When importing this file into our Thinkwise application it interprets e.g. 20.88 as 20.880,00 aka 20880 which is a bit too much šŸ¤

Thinkwise doesn't look at the Windows settings because I can replicate the issue on mu PC except that Excel shows it correctly while on the customer pc Excel also messes it up.

On my PC:
Ā 

Any suggestions on how to deal with this? Is there an option that we have missed to force the decimal separator?


5 replies

Userlevel 6
Badge +16

Which version of the platform and gui are you using?

Userlevel 2
Badge +4

Which version of the platform and gui are you using?

We are using the Windows GUI 2023.3.12

Userlevel 6
Badge +16

And the version of the platform (sf/iam version)?

Userlevel 2
Badge +4

And the version of the platform (sf/iam version)?

Ā 

Userlevel 7
Badge +23

Hi Alban, seems we haven't answered this topic yet. Has it been resolved? Can you try with theĀ latest Windows GUI version?

Reply