Closed

i need a script that takes a standard outlook contact export to a csv file and convers it to a 3 column csv file

Hello all coders, I have a standard export of outlook contacts in the format of a csv. I need it converted to a csv with 3 columns and the multi phone numbers ported to one per line with the mobile,home,business....etc according to which column it is in and appended to the line.

for example the outlook csv will have first name,last name,address.....mobile phone, business phone, home phone, fax

it should be changed to:

first name, last name-Mobile, mobile phone

first name, last name-Business1,business phone

first name, last name-Business2, phone

in phone remove all ( ) -... etc

input of csv:

John,Doe,619-555-1212,6195551313,1(619)555-1234,+1(858)251-5656

output of csv after script:

John,Doe-Mobile,6195551212

John,Doe-Business1,6195551313

John,Doe-Business2,6195551234

John,Doe-Home,8582515656

it should only create a record if the phone number field exists.

outlook fields:

Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,Business Country/Region,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country/Region,Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country/Region,Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,Account,Anniversary,Assistant's Name,Billing Information,Birthday,Business Address PO Box,Categories,Children,Directory Server,E-mail Address,E-mail Type,E-mail Display Name,E-mail 2 Address,E-mail 2 Type,E-mail 2 Display Name,E-mail 3 Address,E-mail 3 Type,E-mail 3 Display Name,Gender,Government ID Number,Hobby,Home Address PO Box,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,Office Location,Organizational ID Number,Other Address PO Box,Priority,Private,Profession,Referred By,Sensitivity,Spouse,User 1,User 2,User 3,User 4,Web Page

Skills: Javascript, Software Architecture

See more: csv create, export script outlook contacts, office manager job, internet radio architecture, hobby etc, free radio code, export job, contact coders, coders in need of a job, car fax, car architecture, business standard, birthday in a box, mobile phone directory, e mail outlook, directory of mobile phone numbers, tdd, street 3, standard, po file, pager, outlook 2013, it architecture, column, architecture office

About the Employer:
( 28 reviews ) san diego, United States

Project ID: #4305795

13 freelancers are bidding on average $59 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$80 USD in 1 day
(36 Reviews)
6.6
slavisatosic

Hello, I am offering you to make this conversion script by tomorrow. Please see private message for details.

$80 USD in 1 day
(101 Reviews)
5.9
siddhu1986

Hi, experienced Web Developer. Good with CSV, Javascript and PHP. Kindly check PMB. Regards.

$30 USD in 0 days
(57 Reviews)
5.3
pentium10

Professional work from professionals!

$100 USD in 2 days
(30 Reviews)
4.9
phpthebest

Hi, I am ready to do this project, check PM.

$30 USD in 0 days
(32 Reviews)
4.9
yeki

I'm an expert .NET developer. Please see your PMB.

$50 USD in 2 days
(7 Reviews)
4.3
LightITGroup

Hello! We're interested in taking up your project. Please PM us and we'll discuss the details. Thank you!

$60 USD in 1 day
(8 Reviews)
4.2
cloudvn

Allow me to help you! Start immediately! Complete in very fast! Check PMB, thanks!

$98 USD in 0 days
(11 Reviews)
3.1
thinhnp

Hi. I have much experience of PHP and working with CSV. I'm ready to start immediately !

$60 USD in 0 days
(3 Reviews)
3.0
binarygeotech

I can create it right now, Please contact me.

$50 USD in 0 days
(5 Reviews)
2.8
workbeezcom

I can help you easily. thanks.

$70 USD in 1 day
(4 Reviews)
2.5
quatroo

I can help you.

$30 USD in 1 day
(4 Reviews)
2.2
a1itpartner

hi, i am ready to start your work.

$30 USD in 1 day
(0 Reviews)
0.0