Discussions
Exporting address to CSV - carriage returns
We are exporting our quotes to CSV to do entry into another system. We are successfully getting all of the fields we need, but we just have one issue we can't find an answer too.
When exporting the Bill-To or Ship-To addresses, most of the records have have address lines showing up as one long string of text in a single field. It looks like some records have a hard return after Address Line 1, but not many.
Can anyone explain how to get hard returns after each line of the address into every record of the output CSV file?
Here's what I get: