sedang Berlangsung

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.

Keahlian Regular Expressions

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 83 ulasan ) Oconomowoc, United States

ID Proyek: #11733317

Diberikan kepada:

MimiFL

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 Lagi

$25 USD dalam 0 hari
(3 Ulasan)
1.8

4 freelancer menawar pada rata-rata $18 untuk pekerjaan ini

fb5761380584329

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 Lagi

$10 USD dalam 1 hari
(0 Ulasan)
0.0
trueinfos

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 dalam 1 hari
(0 Ulasan)
0.0
$25 USD dalam 1 hari
(0 Ulasan)
0.0
a124hmq09u39d

I can do it by manipulating your data.

$20 USD dalam 2 hari
(0 Ulasan)
0.0