CSV to JSON, fix special chars issue

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I need to split the columns of a CSV based on the ; character. Each CSV column containing data has a " " around it. While fetching the URL with the CSV, there is an issue with weird chars. Words end up as "Hintergr&uuml" and cause extra unwanted ; and " in the script.

$result = file_get_contents($url);

html_entity_decode($result);

$linecount = substr_count($result, "\n");

$str_arr = explode("\n", $result);

for ($i = 1; $i <= $linecount; $i++){

$data_line = explode(";", $str_arr[$i]);

//$data_line = str_replace('"', '', $data_line);

PHP Software Architecture

Project ID: #14015570

About the project

18 proposals Remote project Active 6 years ago

18 freelancers are bidding on average €37 for this job

rinsadsl

Hi there I know how to split a csv file with semicolon and double quote. I have split csv files with html content with semicolon without compromising the content inside double quotes. Looking forward to work with yo More

€33 EUR in 2 days
(1309 Reviews)
9.6
vano101

Hello. Can you send sample of CSV file? I would like to make sure I understand it correcty. Does your CSV file contains quited strings? Thanks.

€14 EUR in 1 day
(1291 Reviews)
7.9
srinichal

Ready to discuss further details about the project and deliver the same to your specifications and needs

€23 EUR in 1 day
(152 Reviews)
7.5
Torricelli

Hi, i hope you're doing well. I've just read your project's description and i would like to help you with it. I'm an experienced web developer with the necessary skills for getting this job done. Responsibilit More

€30 EUR in 0 days
(293 Reviews)
6.7
Sonicoders

I have 3 years experience as a web development will fix your issue inbox me we can discuss more over chat.

€23 EUR in 0 days
(157 Reviews)
6.6
glennwilkins

sir pm me im good in php .. i can do this .. sir pm me im good in php .. i can do this .. sir pm me im good in php .. i can do this ..

€30 EUR in 0 days
(243 Reviews)
6.6
thewebscraper

hi, i can easily fix this for you. please provide the test url and the current function you have.

€29 EUR in 0 days
(77 Reviews)
6.7
codetastic

Hello, I am an experienced PHP coder with expertise in data processing applications. I would be happy to help. Regards, Erik

€34 EUR in 3 days
(47 Reviews)
6.2
gopasoft

Hey, I am interested in your project. Please reply me so that we can discuss in more details. Looking forward to hear from you. Best regards, Rizwan.

€30 EUR in 1 day
(48 Reviews)
5.4
Lionanaimal

I am Saleh A software and javascript expert with 13 years experience I will fix this issue within the next 2 hours Regards

€30 EUR in 1 day
(19 Reviews)
5.1
bdphpguru

Dear Sir, Able to start right now. I have more than 2+ years experience in web and deskop application development using C#.Net , mysql,php. Twillio sms gateway api,paypal api several api like twitter, bitcoin. More

€14 EUR in 0 days
(90 Reviews)
5.2
oldhendra

Hi. May I know how this ; (semicolon) separator get stored inside each CSV lines or perhaps I could see the actual URL or just a few lines as example? I may have to test this first and let you know. Else if you mea More

€30 EUR in 2 days
(18 Reviews)
4.6
GITTechBAY

I am ready to work on your task as per the requirement , please message me More

€23 EUR in 1 day
(2 Reviews)
0.4
marryparker

Greeting there, Programming is my passion.I'm an energetic and passionate web developer. I've been developing websites through PHP and CMS for 6 years now and have worked several projects on freelancer and other More

€28 EUR in 1 day
(0 Reviews)
0.0
sanakashif906

Hi, I have found error in last line. please reply me back so let you know & start working ASAP. Thanks for opportunity.

€34 EUR in 1 day
(0 Reviews)
0.0
joeb929

Hefty experience with PHP. Will work with you to get a small sample which has the error, and produce a working solution with comments explaining every step of the way, so as to make it easier to understand in the futur More

€16 EUR in 1 day
(0 Reviews)
0.0