Properly escape a double quote in CSV

csv escaping
srgb picture srgb · Jul 23, 2013 · Viewed 143.7k times · Source

I have a line like this in my CSV:

"Samsung U600 24"","10000003409","1","10000003427"

Quote next to 24 is used to express inches, while the quote just next to that quote closes the field. I'm reading the line with fgetcsv but the parser makes a mistake and reads the value as:

Samsung U600 24",10000003409"

I tried putting a backslash before the inches quote, but then I just get a backslash in the name:

Samsung U600 24\"

Is there a way to properly escape this in the CSV, so that the value would be Samsung U600 24" , or do I have to regex it in the processor?

Answer

user4035 picture user4035 · Jul 23, 2013

Use 2 quotes:

"Samsung U600 24"""

Related questions

Pandas exporting to_csv() with quotation marks around column names

For some reason I need to output to a csv in this format with quotations around each columns names, my desired output looks like: "date" "ret" 2018-09-24 0.00013123989025119056 I am trying with import csv import pandas as pd Y_pred.…

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More
Writing a pandas DataFrame to CSV file

I have a dataframe in pandas which I would like to write to a CSV file. I am doing this using: df.to_csv('out.csv') And getting the error: UnicodeEncodeError: 'ascii' codec can't encode character u'\u03b1' …

Read More