Delimited data

Delimited data is stored as two-dimensional arrays of data, where fields are separated by a delimiter. Any character may be used as a delimiter, but the most common delimiters are the comma, tab and colon. Comma Separated Values (CSV) files use a comma as the delimiter. Fields can be any length. Each record should contain the same number of comma-separated fields.

Note: When saving an Excel spreadsheet in .csv format, a double quote is wrapped in two double quotes, resulting in a triple set of double quotes. This should be avoided because SSC is unable to process a triple set of double quotes.