Regex replace to return the match instead of replace

[mauricio]

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 solution]

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

Bacon

[abacon]

@mauricio If this worked for you, please accept it as the solution so others may find it faster.

[Qiu · Accepted solution]

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