Trying to trim leading zeros in text field.....

[mamawong50]

I have a text field. Each field has a single entry with varied numbers of leading zeros..."00345", "01025. These numbers are house numbers in an address. I need to remove the leading zeros from the data. Is there a function available that would trim the zeros out?

[cjaeger]

just make it a number field and set the display options ...

or use an aux calc field TexttoNum(field1)

[cjaeger]

OK, this is Scriptmaker forum, so

SetField field1, TextoNum(field1)

replace all would do also....

[LindaG]

Hi,

If the zero-leading numbers exist within an address line (and it sounds like they do), then using Set Field (I think) will remove all text and leave just the number. And if the address is something like 03480 W. 18th, the '18' will also remain. I hope a backup is being implemented before trying any solution.

Linda

[mamawong50]

Thanks.... I used the following solution and it worked...

.... use an aux calc field TexttoNum(field1)

[Lee Smith]

So what does your result do for this situation.

00123 S. Street Apt 101

When it returns this "123101"

Lee

[cjaeger]

Hi Lee,

I think he mentioned something about

>single entry with varied numbers of leading zeros

so I assumed he already used the WordsLeft() function to extract the house numbers into a separate field ...