Data extraction/cleansing from a CSV file then cleansed data into another CSV file

  • Posted:
  • Proposals: 8
  • Remote
  • #684352
  • Completed
Lindsay C.Stephanie M.Mahtab H.Lovely S.Md H. + 3 others have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Estimated Job duration: less than 1 week
Looking for someone to extract firstname, lastname and email from a CSV file which is jumbled to the eye. Once the CSV file has been studied you will be able to decipher the first name, last name and email address of the contacts which have been downloaded from a software. Not sure how many records are in there as it's messy (over a couple columns) but as we only need the ones with email addresses and firstname so I think once cleansed it'll approximately be 700 contacts.

This is example of line 1 column 2 of the CSV file:

TAYLOR'Suzanne Taylor'01245 2564062(‘suzanne.taylor@talktalk.net'

So from this we would be able to get

Suzanne Taylor suzanne.taylor@talktalk.net

We need a firstname and email address for sure, and if there's a surname then this too.

A proficient of understanding of Excel/Numbers will be required to complete this task.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.