← All features

Canvas nodes

String Split

Split text into columns at a delimiter.

How it works

Choose the text column, the delimiter, and how many pieces to produce. The pieces appear in separate columns for later steps.

Click String Split on Canvas, then change Delimiter in the inspector. The hyphen separates the order code into two columns.

Simple example

Choose OrderCode, set the delimiter to a hyphen, and keep two pieces. A code such as WEB-184 becomes separate channel and order-number fields.

String Split selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

3 rows
OrderCodeAmount
WEB-18422
SHOP-08649
WEB-20135

Node output

3 rows
OrderCodeAmountOrderCode_1OrderCode_2
WEB-18422WEB184
SHOP-08649SHOP086
WEB-20135WEB201

Complex workflow

Split a warehouse path such as EAST/AISLE-3/BIN-7 into three pieces while keeping the source path. Count rows by the first piece to compare warehouse totals and still retain the aisle and bin columns upstream.

String Split selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

5 rows
LocationSKU
EAST/AISLE-3/BIN-7MUG
EAST/AISLE-2/BIN-4BOWL
WEST/AISLE-5/BIN-1TRAY
WEST/AISLE-1/BIN-2LAMP
EAST/AISLE-3/BIN-8CUP

Node output

5 rows
LocationSKULocation_1Location_2Location_3
EAST/AISLE-3/BIN-7MUGEASTAISLE-3BIN-7
EAST/AISLE-2/BIN-4BOWLEASTAISLE-2BIN-4
WEST/AISLE-5/BIN-1TRAYWESTAISLE-5BIN-1
WEST/AISLE-1/BIN-2LAMPWESTAISLE-1BIN-2
EAST/AISLE-3/BIN-8CUPEASTAISLE-3BIN-8

Workflow result

2 rows
Location_1count_rows
EAST3
WEST2