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