Trimming Leading zeros

[scott1971]

Hi there,

I have a string field 30 characters long and it's filled with clients locations. Examples are as follows,
"Glasgow"
" London"
"Paris "
" 00001234"
" 00000001"
" 0023 "
I can use Trim which is fine but I need to ditch the leading zeros from the fields and as you can see the length isn't constant, any help would be much appreciated.

Using CR XI.

Thanks

 

[bdreed35]

Try this in a formula:

local stringvar input := trim({table.field});

if isnumeric(input)
then totext(val(input),0,"")
else input

~Brian

 

[scott1971]

Excellent, thanks for that, works a treat!