Make.com LabIntermediate
Extract Part of a String with substring() in Make.com
Invoice numbers start with a 3-letter type code. Extract that code to route invoices with a Router.
Live Execution Simulator
Idle
π₯
Incoming Data
βοΈ
Make.com Node
π―
Next Step
> Ready. Type your expression below and click "Check Answer" to run the node.
Incoming Payload / Data:
{
"invoice_no": "INV-2026-0042"
}
Press Enter or click Check Answer. +20 XP
β Solution & explanation
substring(invoice_no; 0; 3)
Output: INV
substring(text; start; end) returns the characters from start up to (but not including) end. Positions start at 0, so 0; 3 returns the first three characters.π‘ Pro tip: Unlike arrays in Make (which start at 1), text positions start at 0 β a classic source of off-by-one errors.