I have to do some massaging of our parcel data to make it usable by a program in sheriff helicopters. The program requires one of the following address formats within the fields:
Our addresses are currently in one field:ex: 1234 W Main St.
Is there a way to automate the splitting of the fields into either of these desired formats?
I can imagine the two field format would be easier by just calling for a split after the numbers, but could also cause a problem for streets such as 1st Ave, etc.
أكثر...
Our addresses are currently in one field:ex: 1234 W Main St.
Is there a way to automate the splitting of the fields into either of these desired formats?
I can imagine the two field format would be easier by just calling for a split after the numbers, but could also cause a problem for streets such as 1st Ave, etc.
أكثر...