Community
Showing results for 
Search instead for 
Do you mean 
Reply

Breaking Street Address field into separate fields

New Member
Posts: 2
Country: United States

Breaking Street Address field into separate fields

I need to separate the street address field into unique fields...  Address1 "2015 N Baltimore St"  would break into AddressNo "2015", AddressDir "N", AddressSt "Baltimore", and AddressType "St."  Any Add-Ons out there?  Or, what Excel equations would do that and then I could export/import?

Thanks,  T

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Breaking Street Address field into separate fields

Check out Automatic Field Calculations addon from Exponenciel.com.

 

It looks like you might be able to pull something off like you want with out going to the hassle of import/export.

 

They have a 21 day demo - not sure if it is limited in some way, but should allow you to get a sense if it can work.

 

Back up your database!!!