Regex replace to return the match instead of replace

Question

Hey guys,

Is there a simple way to return a regex match instead of replacing it using the REGEX_Replace function?

Example

I want to return “2005” from the string “abcd_2005_12”

Match 4 digits in a row is simple: \d{4},

Match everything other than \d{4} and replace it with "" is much more difficult.

Thanks!

abacon · Accepted Answer

@mauricio Use the RegEx tool and use the tokenize method. This will split out to new columns the value you search for.

Bacon

Qiu · Accepted Answer

@mauricio 
If we have to use "REGEX_Replace" function, maybe we can do like this.