Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Regex substring formula

Hi! I want to create a formula that returns the partial match of a string given a regex like this ^[A-Z][0-9] which will find and return KA7030 in the formula column. Is that possible?

KA7030ROJO1
KA7030ROJO2
KA7030ROJO3
KA7030ROJO4
KA7050PIEL4

Regex substring formula

Hi! I want to create a formula that returns the partial match of a string given a regex like this ^[A-Z][0-9] which will find and return KA7030 in the formula column. Is that possible?

This is an example dataset

KA7030ROJO1
KA7030ROJO2
KA7030ROJO3
KA7030ROJO4
KA7050PIEL4