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.
