Separate a Column into Two

Separate a Column into Two

Extract specific information from one column into separate fields.

In this tutorial, we’ll show you how to separate street name and street number into two distinct columns using the Shopify field "Address First Line".

Steps to Split Address First Line:

Select the "Address First Line" field
Use the search field (e.g., type "address") to quickly locate the relevant field.

Add two new columns
Go to the "Columns" section and add two columns.
The value must match the "Selection" exactly, enclosed in double curly brackets:

{{ Shipping Address: Address First Line }}

Don't forget to click "Add"!

To fully understand the functionality please take a look at: Set the Value of a Column

Set the format options for "Street Name" and "Street Number"
To extract the correct details from {{ Shipping Address: Address First Line }}, we need to apply formatting rules.
Open "Format Options" and configure the following settings under "Find and Extract Character Sequence":
- Street Name: [\D]+
- Street Number: [\d]+

Explanation:

[\D]+ (regular expression) extracts all non-numeric characters (i.e., the street name).
[\d]+ (regular expression) extracts all numeric characters (i.e., the street number).

For further details, refer to: Regex for Search and Replace

Preview the result
Click on the "Preview Button" to check to result of the report.

Save and test your report
In the top-right corner, click "Update & Run" to generate the report.

Omit the original column output (optional)
If you only need the separated columns, you can omit the original "Shipping Address: Address First Line" column.
This option is available under "Format Options".

Updated on: 11/03/2025