Clean up a CSV file

Proyek ini berhasil diselesaikan oleh MimiFL dengan harga $25 USD dalam sehari.

Dapatkan penawaran gratis untuk proyek seperti ini
Pemberi kerja bekerja
Anggaran Proyek
$10 - $30 USD
Diselesaikan Dalam
1 hari
Total Penawaran
Deskripsi Proyek

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.

Ingin menghasilkan uang?

  • Atur anggaran Anda dan jangka waktunya
  • Uraikan proposal Anda
  • Dapatkan bayaran atas pekerjaan Anda

Pekerjakan para freelancer yang juga menawar di proyek ini

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