Workflow · Clean · Opening soon

Split a column by delimiter

Split one column into several by a delimiter, like commas. Use it to turn address text into street, city, state and zip columns.

Book a demo

Someone typed

“split the address column by commas into street, city, state and zip columns”

The agent read it as

Split the address column by commas into street, city, state and zip columns in Customer list.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Customer list

CSV export · 16 rows

Step

Split address into columns

Step 1

Result

Split Customer Addresses

16 rows

Schedule

Runs when you say

Proposed

File
Customer list
CSV export · 16 rows
Step
Split address into columns
Step 1
Result
Split Customer Addresses
16 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 16 rows came out.

Download Customer list sample (16 rows)Excel: open the worksheet and save as CSV

What you get back

The result of that run, the rows to look at first.

Split Customer AddressesSample data16 rows

customer_id	company_name	address (source)	Street	City	State	Zip
CUST-1001	Northwind Supply	125 Alder St, Portland, OR 97205	125 Alder St	Portland	OR	97205
CUST-1002	Blue Harbor Cafe	88 Market St, San Francisco, CA 94105	88 Market St	San Francisco	CA	94105
CUST-1003	Evergreen Dental	410 Pine Ave, Seattle, WA 98101	410 Pine Ave	Seattle	WA	98101
CUST-1004	MetroFit Studio	22 W Elm St, Chicago, IL 60610	22 W Elm St	Chicago	IL	60610
CUST-1005	Silverline Books	700 King St, Alexandria, VA 22314	700 King St	Alexandria	VA	22314
CUST-1006	Cedar & Stone LLC	19 Broadway, New York, NY 10007	19 Broadway	New York	NY	10007
CUST-1007	Harbor Point Foods	501 Ocean Blvd, Long Beach, CA 90802	501 Ocean Blvd	Long Beach	CA	90802
CUST-1008	Redwood Works	77 Lakeview Dr, Austin, TX 78701	77 Lakeview Dr	Austin	TX	78701
CUST-1009	Summit Tech Labs	2400 Main St, Denver, CO 80202	2400 Main St	Denver	CO	80202
CUST-1010	Prairie Market	15 Lincoln Way, Des Moines, IA 50309	15 Lincoln Way	Des Moines	IA	50309
CUST-1011	Sunline Logistics	3000 River Rd, Newark, NJ 07105	3000 River Rd	Newark	NJ	07105
CUST-1012	Juniper Home Co	14 Birch Ct, Madison, WI 53703	14 Birch Ct	Madison	WI	53703

16 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you split a column by delimiter?

Upload the Excel export with your address column. Then choose the delimiter, such as a comma, and map the split parts into street, city, state and zip columns. Mammoth applies the same rule to the rows in your customer list.

How it works

How to use the Split Customer Addresses workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Split Customer Addresses: questions

Which export should you use from Excel?

Use the file export that includes the column you want to split. The sheet should have the full address text in one column, with one row per record.

What happens to rows that do not match the delimiter?

Rows that do not contain the delimiter, or do not split into the expected number of parts, are left out of the split result or kept unchanged, depending on the rule you set.

How do you change the split rule?

Edit the step in words. You can change the delimiter, the source column, and which output columns receive each part of the split.