What is the problem?
CSV file was generated correctly, but certain fields included quotation marks. Unfortunately, our partner system was unable to handle this format, resulting in failed imports and additional manual work.
Hello @Marius, can you share screenshots of the issue?
But you can try this (Add a Set Variable before the CSV creation that uses replace() to remove or replace commas, quotes, and line breaks from field values. For example: {{replace(replace(fieldValue; ","; " "); newline; " ")}} removes commas and line breaks.)
Hi @Marius,
The values are double-quoted in case any of them contain actual double quotes.
As @Pathfinder_Automate suggested already, you can remove them using a replace() function on the final CSV output, but keep in mind your external will not parse it correctly if any values DO contain a double quote.
If your data is guaranteed to not contain double quotes in any values, then that should work find for you.
For a more robust setup, you might find out from the partner system what format you need to use when a value needs to contain a double quote character (perhaps it needs to be escaped?). In that case, use a Make Code step to rewrite the CSV accordingly, use AI to help write you a script to do it.