Skip to main content
Solved

CSV import and decimal separators

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

Jeroen van den Belt wrote:

Hi @Alban_T,

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

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

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Forum|alt.badge.img+17

Which version of the platform and gui are you using?


Forum|alt.badge.img+6
  • Captain
  • January 2, 2024
Erwin Ekkel wrote:

Which version of the platform and gui are you using?

We are using the Windows GUI 2023.3.12


Forum|alt.badge.img+17

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


Forum|alt.badge.img+6
  • Captain
  • January 2, 2024
Erwin Ekkel wrote:

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+9

Hi @Alban_T,

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


Forum|alt.badge.img+6
  • Captain
  • April 17, 2024
Jeroen van den Belt wrote:

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+9

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
  • Captain
  • May 1, 2024
Jeroen van den Belt wrote:

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 😇
 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings