CSV FILES

• CSV

EMBEDDING SPECIAL CHARACTERS

• Dealing with commas and double quotes
• Fields that contain double quotes

EMPTY VALUES

3 Ways to deal with encoding empty fields:

1. As a pair of adjacent commas:

   one,,three,four

2. As an empty string, i.e. a pair of double quotes:

   one,””,three,four

3. If the field(s) are at the end of the line they may be omitted.