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

This topic is 4885 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

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

You will have to scan data to see if it follows a pattern. Read up on Middle and Position functions... Or just get AHunter3 to do it for you! He is a zen master!

Posted

the street numbers are always 6 digits long, but as you know, real address numbers can vary in length. so the street name i guess would always start at the 8th character. but i am still not sure how to write this script. I am new to scripting, and very tired of exporting to excel and re-importing back.

Posted

You could do it this way: import the address into the StreetName field, then - while the found set still contains the newly imported record only - follow with:

Replace Field Contents [ Street# ; GetAsNumber ( Left ( StreetName ; 6 ) ) ]

Replace Field Contents [ StreetName ; Right ( StreetName ; Length ( StreetName ) - 7 ) ]

The full Address field should be a calculation field. Note that this assumes the street number contains only digits - otherwise the calculation needs to be more complex.

This topic is 4885 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.