topic Re: Value from text to number in Data Quality

Value from text to number

Ema92 — Thu, 12 Mar 2026 11:50:06 GMT

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

Re: Value from text to number

WeLoveQlik — Thu, 12 Mar 2026 11:56:58 GMT

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=',';

Re: Value from text to number

Ema92 — Thu, 12 Mar 2026 13:07:58 GMT

Tried but not works, thanks

Re: Value from text to number

WeLoveQlik — Thu, 12 Mar 2026 13:11:50 GMT

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

Re: Value from text to number

Ema92 — Thu, 12 Mar 2026 13:34:46 GMT

in load script

Re: Value from text to number

Ema92 — Thu, 12 Mar 2026 14:28:44 GMT

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