CSV / TSV Data Format

FlyData supports data formatted into comma or tab separated lists.

The specifications for CSV and TSV are a little different from RFC 4180.

  • FlyData does not support the use of double quotes to enclose a field and escape characters like commas and tabs.
  • FlyData requires backslash escapes for the following characters:

     

    • , commas, in CSV only.
    • \t tabs, in TSV only.
    • \ backslashes.
    • \n newlines.

For example, if you wanted to upload a CSV file that includes the newline character, this is how you would handle the escape:

01,john,29,Hello I'm John.\\nHow are you doing?

Note: You must create the table on Amazon Redshift before you can upload in either CSV or TSV data format.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk