Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please assist, i have a text that i have to convert into a number.
The text looks loke this 0000000089548436, i need to remove all leading zeros and have a decimal point before two last digits.
a thousand separator should be a space.
The result should look like 895 484.36
Thank you
Hi '
use following expression
=num(0000000089548436)/100
Regards
Anji
Change the load script settings like:
SET ThousandSep=' ';
You can use this formatting/transformation during the load as well.
=Num(0000000089548436,'#,###.#0')