Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4887 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

This topic is 4887 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.