In Progress

Data processing from CSV to text files

I have a database of people (240,000) that are in CSV format with the following headings:

First name, last name, title, address, city, state (2 letter abreviation), zip, phone

I need the data first to be sorted by City (it is already sorted by state so this should be quick and easy)

I then want the data formating into a simple text files ordered by city in the following format with a one line space between each listing:

First name last name title

Address

City

State

Zip

phone

e.g

John peters (BA)

4202 Jenny Lynn Rd

Fort Smith

AR

72901-

907-561-8573

Each State will have its own text file and the data from all the cities in that state will be presented in the format as above

Need a quick turn around

Skills: Data Entry, Data Processing, Excel

See more: text easy, sorted data, quick text, c ar, be smith, jenny g, text format, smith, simple csv, letter g, fort, e letter, data text file, data processing, data listing, data format, CSV, csv data, text processing, ba, ar, sorted, zip city state, cities file, state cities

About the Employer:
( 120 reviews ) manchester, United Kingdom

Project ID: #220748

Awarded to:

nanolab

Ready to start right now.

$120 USD in 1 day
(11 Reviews)
5.6

19 freelancers are bidding on average $145 for this job

livesolutions

Sir We are reayd to start this job ASAP see PM for more details .

$250 USD in 7 days
(69 Reviews)
7.5
adeelarshad

Hi, Plz check pm. Thanks

$125 USD in 1 day
(53 Reviews)
6.6
tas26

i can do this work for you. i have a team of 8 people. waiting for your response....

$175 USD in 6 days
(39 Reviews)
5.9
excelence

lets do it,thanks

$250 USD in 6 days
(2 Reviews)
5.3
denisCh

Please see your PMB

$70 USD in 1 day
(11 Reviews)
4.2
RainbowSearches

Please see PM.

$175 USD in 2 days
(8 Reviews)
3.9
drailean

hello, please check the PM

$180 USD in 0 days
(9 Reviews)
3.8
trans3

Ready to do.

$150 USD in 1 day
(13 Reviews)
3.7
abbass512

well come.

$240 USD in 6 days
(5 Reviews)
3.5
travelagent

hello sir, please check pm for details. regards,

$170 USD in 2 days
(4 Reviews)
3.4
ali23

Hello, I have previous experience of working on projects like these.I will deliver the results within 48-72 hours.Have a nice day!

$45 USD in 2 days
(7 Reviews)
3.1
fastnet

Please see PMB for details. Thanks for Your time.

$50 USD in 0 days
(1 Review)
3.0
hendropra

read my pm, please..

$60 USD in 2 days
(1 Review)
2.9
dubrovsky

I will convert your file in 3-4 hours maximum.

$50 USD in 0 days
(1 Review)
1.2
cherem

Hello Sir, I am ready 2 start immediately, will complete in 3 days or less. Regards, Cheryl

$100 USD in 3 days
(1 Review)
1.0
blm2008

The project will be completed just as wanted or according to the format and will be deliverd right on time.

$225 USD in 8 days
(0 Reviews)
0.0
digitalplanet

Please refer to my private message, thanks.

$250 USD in 0 days
(0 Reviews)
0.0
aanuind

Pls see PMB

$90 USD in 1 day
(0 Reviews)
0.0
carlestops

Hello there. I could manipulate CSV using Excel using a coded ODBC Connection. Pls see PM

$40 USD in 0 days
(0 Reviews)
0.0