Data extraction/cleansing from a CSV file then cleansed data into another CSV file
- or -
Post a project like this3343
£60(approx. $75)
- Posted:
- Proposals: 8
- Remote
- #684352
- Completed
http://www.markitplacements.co.uk/ Sales, Admin, Data Entry, Transcriptionist
Newcastle upon Tyne
20692478975129561640395679167688756766420769023
Description
Experience Level: Intermediate
Estimated project 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.
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.
Andrew H.
100% (35)Projects Completed
32
Freelancers worked with
22
Projects awarded
36%
Last project
15 Jul 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies