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.
What to do
- Specify the delimiter, quote rules and presence of a header.
- Enclose the field and double its internal quotation marks.
- 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.