Clean up a CSV file

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.

Habilidades: Expressões Regulares

Veja mais: csv clean file, load large file csv mysql, load file csv javascript, file csv virtuemart converter, convert text file csv php, mdf file csv, sql server 2005 express import file csv, convertire file csv outlook, load length mp3 files, cgi file csv, text file csv script, upload file csv mysql php script, oscommerce importa file csv xml, vb6 source read txt file csv, function conver file csv html php, php file csv mysql, insert data using file csv sysutil, adr file csv convert

Acerca do Empregador:
( 83 comentários ) Oconomowoc, United States

ID do Projeto: #11733317

Concedido a:


Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (many of them using regular expressions) and i've never had a single problem. If you are intereste Mais

$25 USD em 0 dias
(3 Comentários)

4 freelancers estão ofertando em média $18 para esse trabalho


hello there I'm full-stack developer with four+ years experience, I have enough knowledge and experience to do your job. I have done many complex applications for government organizations. I am newbie on this sit Mais

$10 USD em 1 dia
(0 Comentários)

I am an Excel & Vba macro expert and also done many data entry projects will complete the work with quality and delivery on Time

$15 USD em 1 dia
(0 Comentários)
$25 USD em 1 dia
(0 Comentários)

I can do it by manipulating your data.

$20 USD in 2 dias
(0 Comentários)