Need help dealing with unwanted commas from CSV file upload

Cancelled

Seeking individual that knows how to solve the following problem:

My website involves uploading data to tables via CSV files. Data includes passwords and other content that might include commas. But if any content includes commas, it's treated as a new column and conflicts with the data in the CSV. So I'm looking to find a way to make it so that when the CSV is uploaded, the commas in the content won't be confused with the comma separators.

Example:

CSV data:

------------------------------------------------------------------------------

Column1 | Column2 | Column3

Content1 | Content2a , Content2b | Content3

-----------------------------------------------------------------------------

In the above example, when I upload the CSV file, the comma in Column2 would split the data into 2 columns and insert the data into 2 separate fields. But "Contente2a , Content2b" should be in the same field.

If you know how to resolve this, please let me know. Thanks!

Skills: PHP, Software Architecture

See more: unwanted commas csv, find my passwords, csv data, php split csv files, php upload file csv, split file, software conflicts, unwanted, help solve, php split file, php split csv, file uploaded software, php split insert, content csv, upload csv file, dealing, mikecxtt, csv file upload, upload data csv file php, php file upload csv, find website passwords, file upload field, csv column, column csv, column csv

Project ID: #4484915

40 freelancers are bidding on average $343 for this job

kabirchy

Hi, I like to help you on this. Please view private message. Thanks

$360 USD in 3 days
(719 Reviews)
8.1
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$257 USD in 5 days
(229 Reviews)
7.8
buraqtech

Check your PMB for details!!!

$396 USD in 3 days
(64 Reviews)
7.6
buzzz

For this need change script which parsong Your csv. I can do it.

$525 USD in 2 days
(351 Reviews)
7.5
omtechnologies

Hi! Our PHP Experts can do this project for you professionally. Please check PMB for details.

$386 USD in 4 days
(147 Reviews)
7.4
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$315 USD in 2 days
(355 Reviews)
6.9
zeke

Use different character to separate columns (one which cannot be contained within any of the columns value). Or escape comma within column. For ex.: column1,column2\,containing\,comma,column3 containing backslash: \\. More

$515 USD in 3 days
(141 Reviews)
6.8
oneclickdevelop

Dear Sir or Madam: Thank you for giving us opportunity to submit our proposal for your project. Our company have good team of people which includes: Project Manager, Web Developer, Web Designer, Q/A and Testing sta More

$714 USD in 10 days
(104 Reviews)
6.5
shihan033010

Hi I can give you the solution to resolve the problem. Please accept the bid.

$309 USD in 1 day
(232 Reviews)
6.3
L8G8S

Good evening mikecxtt, I think the problem is more in the code that parse your file than in the uploaded file itself. Could you please send me the php code where the file is read and pushed in your database please? More

$275 USD in 2 days
(48 Reviews)
5.6
csajit

I can help get it fixed!!!

$262 USD in 3 days
(118 Reviews)
5.5
phpplay

I am interested.

$275 USD in 3 days
(18 Reviews)
5.5
BitsLogic

We are a professionally managed IS0 9001:2008 certified web development company. Our team has extensive experience and we have provided services to reputed companies in US, UK, Canada & Europe. Currently we have around More

$550 USD in 3 days
(5 Reviews)
5.4
pablotorres

i can do it

$275 USD in 3 days
(56 Reviews)
5.3
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$618 USD in 7 days
(31 Reviews)
5.4
jigsFLD

Hello, I have experience in various front end design and web design. I'm very interested in your job post involving these skills. I recently worked in an IT company based in India. And I am a skilled designer c More

$262 USD in 5 days
(20 Reviews)
4.8
Voyageinfo

Dear Sir, We are in TOP 1000 among 70000000 freelancer in the world please check PMB. Thanks Voyage Team

$772 USD in 40 days
(13 Reviews)
4.8
ViDeDe

Check PM, please

$262 USD in 1 day
(16 Reviews)
4.4
osinee

HI, I can help you with that - please check PM for more details.

$262 USD in 3 days
(9 Reviews)
4.3
freelancerbuzzo

Check PM, please.

$275 USD in 3 days
(6 Reviews)
4.2