Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Yes! Thank you very much. I adopted that solution and used the replace() to change the hyphen in negative numbers as well.