Upload of CSVs with quotes within cell values

1

Dear community,

I am trying to upload a CSV with cells like the following

"or use ....""DefaultHttpDataFactory.setBaseDir(...)"" ..."

While the client correctly splits and displays the rows, the server misinterprets them and puts them into a “bad rows” datatable.

I used the following settings for importing the CSV:

  • delimiter token: Comma
  • String escape token: double quote

Are the double quotes the correct way to quote within CSV cells? If yes, what can I do to have the file interpreted correctly?

Best regards

2

Please Try with \, e.g.

Col1,Col2
"or use ....\"DefaultHttpDataFactory.setBaseDir(...)\" ...",
,

\ is the “escapeToken”. I think you can’t change it via the upload UI.

1 Like
3

Thx @peter.dahlberg, your proposal works. I had hoped for a solution that does not involve preprocessing the file, but at least it works now