May 1, 2002 at 12:44 pm
I am importing a text file from an international shipping company with ten to 20 thousand lines of customer shipping information. I am using OUTER JOINS to compare the resulting tables to a customer table to assign each of the customer records to an association. I am discovering that the data entry people at the shipping company are uncertain spellers and was wondering if there was a way to take this into consideration when assigning associations. My joins are based on the customer company name and this is where the spelling errors are showing up. I considered using the SOUNDEX function but don't know very much about it. Do you have any suggestions? Thanks
May 1, 2002 at 3:25 pm
Unfortunately unless you create a mapping table to translate mistakes or consider trying partial matches you don't have too much you can do. Soundex may help some but not always. Suggest to the company they improve their entry by adding checks for these names or some other means that will ensure the data can be compared.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply