Completed

Clean up a CSV file

This project was successfully completed by MimiFL for $25 USD in a day.

Get free quotes for a project like this
Employer working
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
5
Project Description

CSV file is in the wrong format. It is semi-colon delimited. There are line returns which need to be persevered. I need the CSV to be 3 columns. Quote, Author, Tags. Each field needs to have quotes around it and pipe delimited.

Example first record:

-------------------------------------------------------------------------------------

"Age is an issue of mind over matter. If you don't mind

it doesn't matter."

-------------------------------------------------------------------------------------

If loaded into excel, this now gets split as 2 columns. it needs to be 1 column.

I will test by loading into Excel.

-Quote needs to include the Quote characters " ".

-Entire quote must load into first column

-please add a field LENGTH, which is the length combining the quote, author + 1 space.

-provide a list of the regular expressions used to clean the data.

For someone who know regular expressions, this should take little time. File is 75K records and will be provided to winning bidder.

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