Value from text to number

[Ema92]

Hello,

i have a problem to convert money that comes from text into numer. Example:
i have many records like this 00000000000058894,00 and i want convert into number. I tried num or num# and other composite formula but none works.

Thanks

Best regards

[WeLoveQlik]

Qlik is likely misinterpreting this string due to the comma. Try to use the REPLACE() function to change the Comma to a '.' and then use NUM or NUM# as you have already tried.

If all of your numbers come in like this 

You might also try changing the following on the main tab

SET DecimalSep=',';

[Ema92]

Tried but not works, thanks

[WeLoveQlik]

Are you doing this in an expression or in the script?

[Ema92]

in load script

[Ema92 · Accepted solution]

Resolved with the function ReplaceRegex like this:

ReplaceRegEx("Importo totale", '^0+', '') with this function i can delete the zeros until found a number different from zero.

Thanks