> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Separate a Column into Two


## ${color}[#1a63ba](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".

${youtube}[](30DYmGeCuk8)

#### ${color}[#1a63ba](Steps to Split Address First Line:)

1. Create an Order Report
2. Select the "Address First Line" field
* Use the search field (e.g., type "address") to quickly locate the relevant field.
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/search_1qjqzmw.png)
2. 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 }}`

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/add-custom-column_o8onh1.png)
|| To fully understand the functionality please take a look at: [Set the Value of a Column](/en/article/set-the-value-of-a-column-gs7fmu/)

3. 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]+` 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/settings_1n3wpp0.png)

#### ${color}[#1a63ba](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](/en/article/regex-for-search-and-replace-17fecst/)

4. Preview the result
* Click on the "Preview" button to check to result of the report.
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/preview_nlcj4b.png)
5. Save your report
* In the top-right corner, click "Save" & "Run" to generate the report.

6. 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".
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/hide_lxuya.png)