Articles on: Tutorials

Separate a Column into Two

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:

Create an Order Report
Select the "Address First Line" field

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

Add custom columns

Go to the "Columns" section and add two custom columns.
Name the custom columns, e.g. "Street Name" and "Street Number"
Insert the value. The value must match the "Selection" exactly, enclosed in double curly brackets:

{{ Shipping Address: Address First Line }}

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 your report

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

Hide the original column output (optional)

If you only need the separated columns, you can hide the original "Shipping Address: Address First Line" column.
This option is available under "Format Options".

Updated on: 26/01/2026

Was this article helpful?

Thank you!