Issue with output file format

Question

Question

Warren Grob · Sep 10, 2018

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?

Discussion (3)0

Log in or sign up to continue

Robert Cemper · Sep 17, 2018

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.

0 0

score 0 · Answer 1 · 2018-09-17T10:00:02-04:00

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!

score 0 · Answer 2 · 2018-09-17T11:38:00-04:00

Eduard Lebedyuk · Sep 17, 2018

Wouldn't it produce strings like this:

stringA","stringB","stringC

leaving strings A and C unquoted?

0 0