Line break in field value breaks csv exports

Help me!
1

Feature(s) impacted

csv exports

Observed behavior

When a field contains a string value with line breaks (provided by a textarea input), then the csv exports for this table is broken. The line breaks in the value are not escaped, and result in actual line breaks in the csv file.

Please provide in this mandatory section, the relevant information about your configuration:

  • Project name: Ma domiciliation
  • Environment name: all
  • Agent type & version: node, “forest-express-sequelize”: “~6.6.3”
2

@kmcb

I just tried to replicate in a test project, and I see that when line breaks are included in the data, double quotes are added in the CSV output, which should parse fine.

Can you try configuring your csv parser with the following settings:
{"delimiter": ",", "escape": "\"" } ?