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

This project received 13 bids from talented freelancers with an average bid price of $59 USD.

Get free quotes for a project like this
Employer working
Project Budget
Total Bids
Project Description

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, 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:
output of csv after script:

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online