How do I remove newline characters or line breaks from my Shopify data during a CSV export?

Some systems may not be able to parse the CSV file properly if the field data contains newline characters or line breaks.

In the Data Settings, under Calculated Fields, you can use a formula like below to strip them out from the Shopify data:

{{ shipping_address.address1 }}.replace("\r", "").replace("\n", "")

This would strip out all kinds of newline characters: CR (carriage return), LF (line feed), or CRLF (carriage return and line feed).


App: EZ Exporter

Tags: csv, advanced features