My Day✳All blog articles ↗

Preserve delimiters inside a CSV note field

Check that a comma inside the note remains text rather than creating another column.

CSV has different dialects. Here the delimiter is a comma and a field containing a comma or quotation mark is enclosed in double quotes. An internal quote is doubled. Verify by parsing the record back, not merely by inspecting its appearance.

2 fields; 1 data row excluding the header
2 fields; 1 data row excluding the header

What to do

  1. Specify the delimiter, quote rules and presence of a header.
  2. Enclose the field and double its internal quotation marks.
  3. Parse back and compare the field count and exact values.

Example

Fictional header item,note assigns K1 and the note Bring "North, South" draft. Record: K1,"Bring ""North, South"" draft". Parsing restores K1 and the entire note: 2 fields, 1 data row. South does not become another column. No My Day CSV import is assumed.

My Day · Windows

Manually save this personal record in My Day.

Buy My Day for Windows ↗