Converting text into a number

[Anonymous]

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

[Akina0929]

Hi '

  use following expression

   =num(0000000089548436)/100

Regards

Anji

[tresesco]

Change the load script settings like:

SET ThousandSep=' ';

You can use this formatting/transformation during the load as well.

[ramasaisaksoft]

=Num(0000000089548436,'#,###.#0')