Skip to main content
Answer

CSV import and decimal separators

  • December 12, 2023
  • 9 replies
  • 179 views

Forum|alt.badge.img+6

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?

Best answer by Alban_T

Hi @Alban_T,

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

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

This topic has been closed for replies.

9 replies

Forum|alt.badge.img+17
  • Moderator
  • December 21, 2023

Which version of the platform and gui are you using?


Forum|alt.badge.img+6
  • Author
  • Hero
  • January 2, 2024

Which version of the platform and gui are you using?

We are using the Windows GUI 2023.3.12


Forum|alt.badge.img+17
  • Moderator
  • January 2, 2024

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


Forum|alt.badge.img+6
  • Author
  • Hero
  • January 2, 2024

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

 


Mark Jongeling
Administrator
Forum|alt.badge.img+23

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


Jeroen van den Belt
Administrator
Forum|alt.badge.img+10

Hi @Alban_T,

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


Forum|alt.badge.img+6
  • Author
  • Hero
  • Answer
  • April 17, 2024

Hi @Alban_T,

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

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


Jeroen van den Belt
Administrator
Forum|alt.badge.img+10

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.


Forum|alt.badge.img+6
  • Author
  • Hero
  • May 1, 2024

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.

the customer is using a differently formatted Excel document 😇