Skip to main content

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?

Which version of the platform and gui are you using?


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)?


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

 


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


Hi @Alban_T,

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


Hi @Alban_T,

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

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


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.


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 😇
 


Reply