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