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.
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 interested, please send me the sample input file (10 rows) and desired output file (again 10 rows) so i can take a look and see exactly what needs to be done. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect.
Thanks, Milan
$25 USD en 0 día
5,0 (3 comentarios)
1,8
1,8
4 freelancers están ofertando un promedio de $18 USD por este trabajo
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 site,
I know It's hard to trust freelancer who have't any task done and review on this site, but I definitely can do your job in short period with clean,good code.
My price for your project is symbolic(5$ for me,it's lowest price)
I just need review, so I will do my best to get good review from you :)
Best regards.