Devam Ediyor

Capture name & address from CSV data

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 “[url removed, login to view]” before doing the larger [url removed, login to view] file so I can be sure my real estate database program will import the data properly.

John Sanner

Beceriler: Veri İşleme

Daha fazlasını görün: set data, first trust, data 0, b j's, 7527 novara naples, verona, my j, final data, usa b, remove from, remove b, pinto, Patrick, name, name only, ln, Larry, jr, john, initials, import two, Gene , ct, csv data, code name one

İşveren Hakkında:
( 2 değerlendirme ) Fort Wayne, United States

Proje NO: #103680

Seçilen:

weebmaster

Hello Please check PMB. Thanks

0 gün içinde 30$ USD
(1 Değerlendirme)
1.0

54 freelancers are bidding on average $38 for this job

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 Daha fazlası

1 gün içinde 30$ USD
(43 Değerlendirme)
6.3
silgate

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

1 gün içinde 60$ USD
(40 Değerlendirme)
6.2
Balky

Hi refer to your pmb please

1 gün içinde 30$ USD
(43 Değerlendirme)
5.6
jmddata

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

in 5 gün içinde30$ USD
(17 Değerlendirme)
4.6
okidokz

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

in 0 gün içinde30$ USD
(12 Değerlendirme)
4.5
nanolab

I will do this for you.

1 gün içinde 30$ USD
(10 Değerlendirme)
4.1
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

in 3 gün içinde30$ USD
(5 Değerlendirme)
3.3
tlchung

let start it now

1 gün içinde 50$ USD
(2 Değerlendirme)
2.6
eIndian

John, I will give you first 75 records from [url removed, login to view] as a sample to check with your website and then you can decide on it. Thanks, Pnkaj

1 gün içinde 100$ USD
(1 Değerlendirme)
1.4
vnb401

kidly refer PMB, thanks

in 0 gün içinde30$ USD
(1 Değerlendirme)
1.4
Raksha

Hello sir, I can do this project. Regards

1 gün içinde 30$ USD
(2 Değerlendirme)
1.6
yokin

hello, can do this in 2 days to your complete satisfaction

in 2 gün içinde60$ USD
(0 Değerlendirme)
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).

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
dieuhq

I need only 25$ for this job. It is very easy to me. I can help you immediately.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
divArts

Hi Sir, This job is simple so I can do it in few minutes. Just drink your coffe and I'll do it for you :) please check PM for detail. Regards, brife.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
amrithavarshini

I can provide it to u as soon as u want it. here is the processed sample.txt. U can checkout if this is fine. PETER,GALLERANI,121 FEATICKET PATH,EAST FALMOUTH,MA,2536- KEITH,SAUNDERS,7507 NOVARA CT,NAPLES,FL,3 Daha fazlası

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
Madhusudhanan

I am ready to do this job, I have vast experience on this kind of job.

in 6 gün içinde60$ USD
(0 Değerlendirme)
0.0
glennbrown

Process files forwarded to you in PM along with a screenshot of the program I wrote for you to do this. [url removed, login to view] processed OK - no errors.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
dataentrysoln

we intrested to do this work.

in 2 gün içinde35$ USD
(0 Değerlendirme)
0.0
bosead

The given examples by you differs from [url removed, login to view] and [url removed, login to view], as these two files include additional fields. Please clarify the importance of these additional fields in the two sample files.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0