sort countries and cities from delimited file
Posted on 2002-03-13
I have a large text file which has over 26,000 records. They are " ~ " seperated. If I import it in excel, I get number of columns depending upon the way I select import option ( like last name, first name, address etc). Now I want that my code could seperate the adress( country, city and zip) from that delimited text file. Once its done it could be exported to SQL server.
The records don't have consistancy. Some times coulmn two has address and along with it city is written, while some times in coulmn three its given city and country. I need to devise an algorithm, so that once its run the recored are seperated and and stored in SQL server in respected fields(like name, city, coutry and post code).
It should recognize if its FL then it florida and its i USA(like stuff.
Hope some one will interact with me and we can come up with a solution