Page Comparison

...

1. Please check for character encoding prior to data ingestion.

2. The file uses:

   1. Separator: comma ,

   2. Text qualifier: double quote "

   3. Escape character: backslash \

3. Escaping special characters:

   1. Records in data files may contain both commas and double quotes, and the way the vendor chose to generate a robust CSV is to escape special characters (double quotes and commas) and add double quotes around each field on top of it.

   2. For CHAR and VARCHAR columns in the data files, an escape character (\) is placed before every occurrence of the following characters:

      1. The delimiter character specified for the unloaded data (in this case, it is “,”)

      2. The escape character: \

      3. A quotation mark character: " or ' (if both ESCAPE and ADDQUOTES are specified in the UNLOAD command). See https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html for more information.

...

• the company name "HEINEN ELEKTRONIK GMBH \"" should be read as HEINEN ELEKTRONIK GMBH "

• the company name (I am just making this example up) "ABC\\DEF 123\, \"INC.\""should be read as ABC\DEF 123, "INC."

Data Dictionary as of 05/12/2021:

...