Is there a way to include commas in CSV columns without breaking the formatting?

Enclose the field in quotes, e.g.

field1_value,field2_value,"field 3,value",field4, etc...

See wikipedia.

Updated:

To encode a quote, use ", one double quote symbol in a field will be encoded as "", and the whole field will become """". So if you see the following in e.g. Excel:

---------------------------------------
| regular_value |,,,"|  ,"", |"""   |"|
---------------------------------------

the CSV file will contain:

regular_value,",,,""",","""",","""""""",""""

A comma is simply encapsulated using quotes, so , becomes ",".

A comma and quote needs to be encapsulated and quoted, so "," becomes """,""".

Related Posts:

  1. Python Pandas Error tokenizing data
  2. “extra data after last expected column” while trying to import a csv file into postgresql
  3. python csv2libsvm.py: AttributeError: ‘_csv.reader’ object has no attribute ‘next’
  4. In Java, what is the “char” for a tab and how do I pass through a “Charset”?
  5. How to parse tsv file with python?
  6. WordPress.com Stats stats_get_csv with custom field?
  7. How to import .csv file with descriptions to a gallery in media?
  8. Updating Custom Posts via CSV Import
  9. CSV import stopped working when I upgraded to WP 3.5.2
  10. IndexError: too many indices for array
  11. Writing a pandas DataFrame to CSV file
  12. IndexError: too many indices for array
  13. Pandas: ValueError: cannot convert float NaN to integer
  14. Python – Reading and writing csv files with utf-8 encoding
  15. Invalid column count in CSV input on line 1 Error
  16. Invalid column count in CSV input on line 1 Error
  17. load csv into 2D matrix with numpy for plotting
  18. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  19. Parsing a comma-delimited std::string
  20. Difference between writerow() and writerows() methods of Python csv module
  21. TypeError: list indices must be integers or slices, not str
  22. Convert from CSV to array in Python
  23. ValueError: cannot index with vector containing NA / NaN values
  24. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  25. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  26. Creating a dictionary from a csv file?
  27. Python import csv to list
  28. append new row to old csv file python
  29. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  30. Writing data into CSV file in C#
  31. Create mysql table directly from CSV file using the CSV Storage engine?
  32. Writing a dictionary to a csv file with one line for every ‘key: value’
  33. Example JavaScript code to parse CSV data
  34. c++ reading csv file
  35. Bulk load data conversion error (truncation)
  36. AttributeError: ‘float’ object has no attribute ‘split’4
  37. How to add pandas data to an existing csv file?
  38. PHP to write Tab Characters inside a file?
  39. How can I output MySQL query results in CSV format?
  40. importing a CSV into phpmyadmin
  41. Dump all tables in CSV format using ‘mysqldump’
  42. Response Content type as CSV
  43. CSV new-line character seen in unquoted field error
  44. JavaScript array to CSV
  45. PG COPY error: invalid input syntax for integer
  46. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  47. How to read a CSV file from a URL with Python?
  48. Export data as CSV in back end with proper HTTP headers
  49. Using a database view = evil incarnate?
  50. Allow CSV files to be uploaded
  51. Woocommerce – Hide “add to cart” on free products
  52. file_exists() acting weird
  53. Jetpack – stats_get_csv period parameter
  54. Best practice for adding posts in bulk
  55. Creating a Wordpess Plugin that writes data to a csv file. The data doesn’t show in the csv file?
  56. Why is file_get_contents returning page source?
  57. Exporting table to csv works in the admin but exports HTML data when used on the front end
  58. code is working properly in Core PHP but writing coding in WordPress
  59. How do I update a field of a meta box?
  60. How to Upload CSV Data into Custom Post Type Data with Metabox programmatically
  61. How to make a wordpress site multilingual by uploading a translated CSV file that has the traslations?
  62. How to export custom database data to excel file
  63. Huge category CSV import does not work
  64. Pulling Data from CSV vs. pulling data from database
  65. WordPress CSV Importer takes a long time to finish
  66. Download full html page with CSV export plugin
  67. Creating a CSV with PHP inside the plugin directory
  68. get csv of users with user_meta
  69. Import CSV to MySQL, with custom registration field information
  70. Can’t upload CSV file to plugin directory using custom upload form in admin panel
  71. Import user data using CSV
  72. CSV to WordPress posts: do I have to populate each possible field?
  73. Can export gallery but can’t import it Wp all import
  74. How to download CSV from sub directory in uploads folder
  75. How to Analyze Blocks and find Intersection and patterns between pages
  76. Custom database table and custom search
  77. How to return/export only data showing on screen in custom post type view all screen
  78. Upload advanced custom field text link array with csv
  79. Creating categories while importing via CSV
  80. help with really simple csv importer
  81. How to map data on CSV to web pages?
  82. Imported posts for cpt are imported as scheduled, not published [SOLVED]
  83. Delete all custom posts then upload a new CSV of events
  84. Updating database with CSV file and Cron job
  85. Front end/Database connection in WP
  86. Force CSV download with template_redirect
  87. Extracted CSV as Array for Custom Query Loop
  88. Issue: CSV file upload works only when “View page source” is done
  89. WooCommerce – Adding Product Attributes to CSV Export
  90. Create csv file in plugin
  91. How to Import Multiple Values in custom field
  92. How to cdv from a custom CMS to WP
  93. Create CSV for import from File directories?
  94. CSV file header
  95. Reading csv from specific directory and insert it to custom post type (cron job)
  96. trouble with passing class method data to outside function
  97. Import users and custom user meta from csv
  98. Exporting CSV of users with custom user taxonomies out of WordPress
  99. Creating posts with php-script + csv
  100. is it possible to use wp cli to export custom post types

Leave a Comment