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

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.

Regex

Accepted answers

All comments

Qiu

@luk

You still can I think

luk

Thank you, I know this tool, but what I want to do is concatenate pattern string like this:

The "key" is one of input field of formula tool. Can RegEx tool also do this without creating macro?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703