I have a list of real property addresses that comes to me from the county. unfortunately the county has an odd way of keeping its records. here is a sample of what a few of them might look like:

001234 Main St

000010 Elm St

098701 Oak St

I need a script that I can run manually or trigger upon import that will separate the address into two fields, the street number without those annoying leading zeros and street name, as well as a field that has the street number and name together, again with no leading zeros.

So visualize the results I need, I need the following 3 fields of results produced:

Street #, Street Name, Address

1234, Main St, 1234 Main St

10, Elm St, 10 Elm St

98701, Oak St, 98701 Oak St

thank you

Answered here:

http://fmforums.com/forum/topic/79354-seperate-address-into-2-fields-and-remove-leading-zeros/page__pid__369883

Please do not double-post.