Support Article
System adds quotes to the data automatically in outbound table
SA-86040
Summary
System adds double quotes to the data automatically in the outbound table which is subsequently passed to the file.
Therefore, unable to parse data with quotes. This occurs only with properties that contain the comma (,) in them.
Error Messages
Not Applicable
Steps to Reproduce
- Create a Strategy.
- Set a value of a property with a comma.
- Create an Outbound table.
- Map the data from that property.
- Update the Offer to write the results to a file.
- Execute the Campaign. Verify the results in the Outbound table or file. The Outbound table and file generated have double quotes.
Root Cause
For file templates, Pega uses a ',' as the default delimiter. If the property value contains a delimiter, Pega encloses the values in double quotes. The delimiter cannot be customised.
Resolution
Apply HFix-55186.
Tags:
Published August 15, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.