How do I use the regex replace formula to pull out all the numbers in a field?

Question

Hi all,

I have a column GL account where all the members are formatted like this: GL_12345_Account Name - Description. How do I use the regex replace to just pull out 12345 into a new column?

I thought it would be something like this but I'm not sure what the second variable "pattern" should be : regex_replace([gl account], pattern, "")

grazitti_sapna · Accepted Answer

Hi @dlee9,

the formula that you are looking for is given below:

REGEX_Replace([FIELD_NAME],"[\D]","").

I hope it solves your issue.