Question

CSV import and decimal separators

  • 12 December 2023
  • 8 replies
  • 113 views

Userlevel 3
Badge +5

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?


8 replies

Userlevel 6
Badge +16

Which version of the platform and gui are you using?

Userlevel 3
Badge +5

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 3
Badge +5

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?

Userlevel 5
Badge +8

Hi @Alban_T,

Can you please respond to Mark his question? Thanks in advance!

Userlevel 3
Badge +5

Hi @Alban_T,

Can you please respond to Mark his question? Thanks in advance!

Ohh sorry, forgot about this one.
This one is resolved.

Userlevel 5
Badge +8

If you are willing to share what did the trick we would love to hear it. In that case I can mark your response as best answer, which may prevent other developers from running into the same problem.

Reply