← All features

Canvas nodes

Find / Replace

Replace matching text or patterns in a column.

How it works

Choose a column and the text or pattern to find. Enter the replacement value and choose whether matches must cover the whole cell.

Click Find / Replace on Canvas, then change Replace with in the inspector. The matching status is now In Review.

Simple example

Choose Status, enter Pending Review in Find, and enter In Review in Replace. Turn on Whole cell to update that label without changing longer status text containing the same words.

Find / Replace selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

4 rows
Order IDStatusReference
A201Pending ReviewRetail
A202Pending Review by ManagerOutlet
A203ShippedRetail
A204Pending ReviewRetail

Node output

4 rows
Order IDStatusReference
A201In ReviewRetail
A202Pending Review by ManagerOutlet
A203ShippedRetail
A204In ReviewRetail

Complex workflow

An imported Order ID column contains several legacy prefixes that should be stripped before a join. Enable Regex, enter ^(LEGACY|OLD)- in Find, and leave Replace empty. Only the matching prefix is removed from each ID.

Find / Replace selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

4 rows
Order IDStatusAmount
OLD-A101Shipped140
LEGACY-A102Pending85
A103Shipped220
A104Cancelled38

Node output

4 rows
Order IDStatusAmount
A101Shipped140
A102Pending85
A103Shipped220
A104Cancelled38