Capture name & address from CSV data

In Progress Posted Nov 3, 2006 Paid on delivery
In Progress 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

Data Processing

Project ID: #103680

About the project

53 proposals Remote project Active Nov 7, 2006

Awarded to:

weebmaster

Hello Please check PMB. Thanks

$30 USD in 0 days
(1 Review)
1.0

53 freelancers are bidding on average $38 for this job

silgate

Hi, ready to start asap. Would deliver in just one day. Look forward for kind hearing from you.

$60 USD in 1 day
(40 Reviews)
6.2
JordanEnt

We are an IT enabled services company specializing in Data Entry, Data Analysis, Market Research and Project Management. We have serviced several international clients in the past and have obtained an excellent feedbac More

$30 USD in 1 day
(43 Reviews)
6.3
Balky

Hi refer to your pmb please

$30 USD in 1 day
(43 Reviews)
5.6
jmddata

Dear sir/mam, Please check PMB. Regards Vinod Arora

$30 USD in 5 days
(22 Reviews)
4.7
nanolab

I will do this for you.

$30 USD in 1 day
(10 Reviews)
4.1
okidokz

Check PM please. Will be done in 2 hours. :)

$30 USD in 0 days
(12 Reviews)
4.5
PRESANNA

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

$30 USD in 3 days
(5 Reviews)
3.3
tlchung

let start it now

$50 USD in 1 day
(1 Review)
2.5
vnb401

kidly refer PMB, thanks

$30 USD in 0 days
(1 Review)
1.4
Raksha

Hello sir, I can do this project. Regards

$30 USD in 1 day
(2 Reviews)
1.6
biznetstar

I can provide it in an hour

$30 USD in 0 days
(0 Reviews)
0.0
gonera

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).

$30 USD in 1 day
(0 Reviews)
0.0
hemant5

check the PM, Thanks

$30 USD in 4 days
(0 Reviews)
4.2
datasolutions12

we can do this work. ready to go

$30 USD in 0 days
(0 Reviews)
0.0
andriezen

can take up the job at your satisefaction.

$45 USD in 3 days
(0 Reviews)
0.0
pbotas

I can provide it in a small windows visual application and/or command line without framework dependencies, in 1 day.

$30 USD in 1 day
(0 Reviews)
0.0
Ellemer

Hi, I can help you.

$30 USD in 0 days
(0 Reviews)
2.0
kannan1980

Work can be completed in 1 day with perfection.

$30 USD in 1 day
(0 Reviews)
0.0
sdclaass

work will be done the way you want it.!!!

$30 USD in 1 day
(0 Reviews)
0.0
jituharjai

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

$30 USD in 1 day
(0 Reviews)
0.0