Address Field Cleanup
Posted on 2007-04-04
I have two fields "address" and "plaintiff address" in table jpdat
Sample Data expected outcome "address" expected outcome "plaintiff"
123 Main Street 123 Main St 123 Main St
123 Main St #21 123 Main St ,21 123 Main St unit 21
123 Main Street #21 123 Main St ,21 123 Main St unit 21
I have created two other tables that have fields "badstring" "goodstring" in tables "Address_Correction" and "Pltf_Address_correction"
Bad String Goodstring
First I am a novice at Access 2000
1. I am looking to clean up addresses in a form based on JPDAT table, using the information in the prespective correction tables. How can I do this? The Address field and the PltfAddress Field need slightly different cleanup. that is why I have two correction tables.
2. if the end of the address such as 123 main st 21 is numbers I want to transfer that into the apartment field. Can I do this based on if there is a street type and if there is not one present.
Thanks for your help in advance
All help would be appreciated.