Hi All,
Is it possible at all to have a line break, e.g. \r\n within the CSV for particular text fields?
An example would be a custom field for addresses, so rather than have:
1 The Close, Best City, BC01 0BC
Instead it’s:
1 The Close
Best City
BC01 0BC
I’ve tried a few variations (\r\n, \r, \n, \\n, \\r) but each time the backslash just escapes the next character and returns whitespace rather than a line break. I’ve also tried double quotes around the text with an actual new line but the import process then thinks this is a new row.
Thanks,
Matt