Warren Grob · Sep 10, 2018

Issue with output file format

I am having an issue with the output file format on a production where quotes (" ") around column values are being removed from the imported file.  For example, my input file is a csv formatted as such: "123", " ", "ABC".  The output file format that is being generated produces: 123, , ABC.  I need the output file to retain the quotes around the data.

Is this something that can be corrected in the record map?  Or is it an issue elsewhere?

1 281
Discussion (3)1
Log in or sign up to continue

Assuming you create your Output by WRITE variable
the most simple solution would be to change it to   WRITE """"_variable_""""

if your variable can contain quotes that need to be escaped WRITE """"_$REPLACE(variable,"""","""""")_""""
may fit your needs.

More sophisticated you may hide the quoting in some macro definition.

The actual answer was much more simple.  In the Record Mapper, first I unchecked the "Quote Escaping" box.  Then once I realized I can have more than one character as a field separator (single comma), I used 'quote comma quote' (",") as my field separator.  Worked as needed. 

Thanks for your input!

Wouldn't it produce strings like this:


leaving strings A and C unquoted?