Closed

Need help dealing with unwanted commas from CSV file upload

This project received 43 bids from talented freelancers with an average bid price of $356 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250 - $750 USD
Total Bids
43
Project Description

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!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online