Generate CSV file by enclosing output values in double-quotes (except for the header record)

Integrator.io
1

Hi Community,

I need to generate a CSV file by enclosing output values in double-quotes (except for the header record).

The expected outcome should be as follows after opening a text editor.

empNumber,employeeId,firstName
"1","005249","emp_firstname_1"

According to my understanding, Celigo offers to add/remove double quotes for all headers & raw values.

This is one of a challenge for me.

Please refer to the below,

In our tenant, the FTP import file type values only support,

  • CSV (or any delimited text file) - See CSV generator helper.

    Custom header rows (optional): In rare cases it is necessary to include one or more custom header rows before the CSV data. Add any such prefix rows in this setting.

  • EDI X12: Get more information on FTP EDI imports.

  • EDIFACT

  • Fixed Width

  • JSON

  • XLSX

  • XML

2

Can you try using custom header rows, wrap quotes, and don’t check include header? For custom header rows, you’ll have to replicate all the headers you’ve mapped in and in exactly the same order.

image
image1494×360 11.8 KB

3

Thanks, Tyler