Properly escape a double quote in CSV

Question

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

User · Answer

If a value contains a comma  a newline character or a double quote  then the string must be enclosed in double quotes  E g   Newline char in this field  n    You can use below online tool to escape    and   operators  https   www freeformatter com csv-escape html ad-output

User · Answer

Not only double quotes  you will be in need for single quote      double quote      backslash     and NUL  the NULL byte    Use fputcsv   to write  and fgetcsv   to read  which will take care of all

User · Answer

I know this is an old post  but here s how I solved it  along with converting null values to empty string  in C  using an extension method   Create a static class with something like the following            lt summary gt          Wraps value in quotes if necessary and converts nulls to empty string          lt  summary gt           lt param name  value  gt  lt  param gt           lt returns gt String ready for use in CSV output lt  returns gt      public static string Q this string value                if  value    null                        return string Empty                    if  value Contains          value Contains          value Contains         value Contains                              return        value                           return value          Then for each string you re writing to CSV  instead of   stringBuilder Append  WhateverVariable      You just do   stringBuilder Append  WhateverVariable Q

User · Answer

Use 2 quotes    Samsung U600 24

[csv] Properly escape a double quote in CSV

Examples related to csv

Examples related to escaping