H
hughess7
Hi, found ways to add leading zeros but is there an easy method to remove
them from a text field? I have data like the following examples and want to
trim all the leading zeros:
0000002
0000102
0000016
Just for reference the field does contain valid leading zeros too (hence its
a text field and a not a number type). The table holds data for lots of
countries, I only want to remove the leading zeros for one particular country.
Thanks in advance for any help.
Sue
them from a text field? I have data like the following examples and want to
trim all the leading zeros:
0000002
0000102
0000016
Just for reference the field does contain valid leading zeros too (hence its
a text field and a not a number type). The table holds data for lots of
countries, I only want to remove the leading zeros for one particular country.
Thanks in advance for any help.
Sue