Convert text to number

[HarshChachara]

I receive numbers in a format such as '000000000451'

 I am looking to convert the above to numbers i.e. 451

I have tried using Num(), Num#(), Evaluate() but can't seem to get it working.

Could you please advice?

[martinpohl · Accepted solution]

there's a tricky workaround

replace(ltrim(replace(Yourfield,'0',' ')),' ','0')

-> replace all 0 with space

-> delete all left spaces

-> replace all spaces with 0

000467 -> 467

Regards

[HarshChachara]

Yes! Thank you very much. I adopted that solution and used the replace() to change the hyphen in negative numbers as well.