Separate a column into two

Separate columns from information in one column

In this tutorial we show how to provide street name and street number in separate columns using the Shopify field "Address first line".

1. Select the field "Address first line"

   Tip: Use the search field - like in this example "address" to find the fields you are looking for.

2. Next add two columns at "Columns" with this setup:

   

   The value must be exact the same name as the "Selection" - surrounded by double curly breaks:

   {{ Shipping Address: Address first line }}

   Tip: Don't forget to click on "Add"!

   To fully understand the functionality please take a look at:

   Set the value of a column using values of other columns and using math expressions

3. Set the Format Option for "Street name" and for "Street number":

   To extract the right information out of {{ Shipping Address: Address first line }} we need to add some 'magic'.

   Open the "Format Options" and add at "Find and extract character sequence" for "Street name": [\D]+ and for "Street number": [\d]+

   Explanation:

   • [\D]+ is a regular expression and will extract the "no numbers" part.

   • [\d]+ is a regular expression and will extract the "numbers" part.

   For further information please take a look at: Regular expressions

4. Save and test your report

   In the upper right corner choose "Update & Run".

5. Omit column output

   If you are happy with the output and you only need the separated columns you can choose "Omit column output" for "Shipping Address: Address first line". You find this option again under "Format Options".