Solved: Re: convert Number - Qlik Community

jeremy_hauspie · ‎2019-04-16

Hi,

I load numbers from a csv document, but the separation between the decimals is a '.'. I want to convert this in the loadscript to a ',' so I can do calculations with the numbers..

In csv number is 394.88 but I want to have 394,88.

There a to many csv files to convert it manually in each file..

PrashantSangle · ‎2019-04-16

Use Replace() to concert '.' to ','

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2019-04-16

Use Replace() to concert '.' to ','

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

jeremy_hauspie · ‎2019-04-16

Many Thanks! it works

PrashantSangle · ‎2019-04-16

close the thread by select answer as correct and like

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂