How do I remove duplicate consecutive spaces from the Shopify data on export?

You can use the formula below in EZ Exporter to remove duplicate spaces from the Shopify field value:

" ".join({{ field_id }}.split())

For example, an order's note field might have this data:

I like     using    tons of   extra                  spaces

Using this formula:

" ".join({{ note }}.split())

Will output:

I like using tons of extra spaces

Note that this will also automatically remove tabs and newline/carriage return/line break characters and replace them with a single space.  So if the original data looks something like this:

I like     using    tons of   extra                  spaces.


And also lots of line breaks.

The output wil look like this:

I like using tons of extra spaces. And also lots of line breaks.

App: EZ Exporter

Tags: advanced features, data export