10-08-2009 02:26 AM
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?
10-09-2009 07:42 AM
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!!!