After upgrade to v28, my csv export output has changed.


I use a custom layout to print invoices exported as csv ready for import into a warehouse management system. 

I require the csv output first row to be header data, I have achieved this using an IF ELSE statement to output a string using escape characters \" for quotes and \n for newline.

Since the upgrade to Sage v28, the \" now results in two double quotes e.g.


which is rejected by the warehouse system. If I don't use the \", the quotes are removed which resulted in another issue with \n.

My question is how can I get just one " to appear or if that isn't possible, how to output a string followed by a line break without using the \n in the string.