Skip to main content
Solved

CSV import and decimal separators

  • December 12, 2023
  • 9 replies
  • 228 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

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


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
  • Software Architect
  • April 2, 2024

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 😇