FAQ: How can I splice a field like Special Instructions to separate the long value into two columns on a CSV file?

You can use the handlebars function “substring”. Here is an example, using the "Special Instructions" field (which is in brackets due to the space in the field name). This will separate a longer field into multiple columns:

COLUMN1: {{substring [Special Instructions] 0 100}}
COLUMN2: {{substring [Special Instructions] 100 200}}
COLUMN3: {{substring [Special Instructions] 200 300}}

We know that handlebars can be confusing and we've put a lot of great examples in our Handlebars helper reference. We're also adding handlebars questions we're hearing from other customers, so please keep your handlebars questions coming!