Amazon S3 output

[sjfearnside]

When writing to Amazon S3 we have the fields delimited by a comma (,). The rows are enclosed in double quotes. The Quotation Mark property in the S3 stage controls the column quotations. is there a property or setting that will turn off the double quotes for the rows?

Ex: this is what Amazon S3 admin is seeing in the S3 files
"LCLS,306048214593355542501394290,20-JAN-20 02.39.14.565007 PM"
"LCLS,994570338530973782655923294,20-JAN-20 02.43.28.350008 PM"
"LCLS,234645550397601429848923658,20-JAN-20 03.24.18.888892 PM"

Thanks

[jhmckeever]

You need to specify the 'Row delimiter' under the 'File format' section on the Stage - Properties tab.

Options are:

• Carriage return <CR>
  Line feed <LF>
  New line <NL>
  Tab <TAB>
  Unicode escape string

For double quotation mark I believe you need to use the \u0022

[sjfearnside]

Thanks