Capture name & address from CSV data
$30-100 USD
Paid on delivery
The task is to capture name and address data from about 700 CSV records. The final data set needs to be in the form:
firstname,lastname,alphanumeric address,zip+4.
There should be only one comma between fields. Extra commas must be removed. When there are two first names use the man’s name only. When there are two owners with different last names, choose the first person listed. Remove all initials. All data after the zip code is to be discarded. Records that have addresses outside the USA , if any, should be discarded.
Examples:
JEROME J & THERESA B,PINTO,7576 NOVARA CT,,,,NAPLES,FL,34114-2612
Becomes
JEROME,PINTO,7576 NOVARA CT,NAPLES,FL,34114-2612
LARRY GENE,SPEES TR,BEVERLY KAY SPEES TR,SPEES FAMILY TRUST,UTD 9/10/03,7536 NOVARA CT,NAPLES,FL,34114-2612
Becomes
LARRY,SPEES,7536 NOVARA CT,NAPLES,FL,34114-2612
PATRICK J & LINDA,MCCAIN JR,7924 RICHARDSON LN,,,,TINLEY PARK,IL,60487-9239
Becomes
PATRICK,MCCAIN,7924 RICHARDSON LN,TINLEY PARK,IL,60487-9239
The final file from the above records would be:
JEROME,PINTO,7576 NOVARA CT,NAPLES,FL,34114-2612
LARRY,SPEES,7536 NOVARA CT,NAPLES,FL,34114-2612
PATRICK,MCCAIN,7924 RICHARDSON LN,TINLEY PARK,IL,60487-9239
File extension is to be .TXT
Please process the file named “[login to view URL]” before doing the larger [login to view URL] file so I can be sure my real estate database program will import the data properly.
John Sanner
Project ID: #103680
About the project
Awarded to:
53 freelancers are bidding on average $38 for this job
Hi, ready to start asap. Would deliver in just one day. Look forward for kind hearing from you.
Sir, I can do it at a total cost of 30 dollars and shall complete the work within 72 hrs. Kindly send me the work. Thanks
It's simple and i think everything in your description is clear for me. I propose small command line C# (.NET) application and additional simple GUI (Window Form).
I can provide it in a small windows visual application and/or command line without framework dependencies, in 1 day.
I have done various data base projects to include new product launch programmes, advertisement pasting etc you can get the job don in less than $30 try me