Does Alteryx has a simple Regex_search to return first matched substring in formula tool?

[luk]

I'm trying to extract sub-string from a main string,  e.g.  extract "c1234" from "abc1234efg".  In the past I can use a simple pattern "c\d*" to get what I need, but in Alteryx formula it seems doesn't have any way to do this.  The closest way is use REGEX_Replace,  but I have to change pattern to ".*(c\d*).*" plus use a mysterious "$1" in the end,  which is much more complicate and counter-intuitive.

I know there is a tool called "RegEx", but it does not support concatenate pattern string according to previous fields.

Does anyone have any idea about how to fulfill this function?  Thank you.

[BretCarr]

Well that’s good and bad news. I’m on a mobile phone right now.