Extract specifics data from a String with REGEX

[Erike]

Hi all, I'm trying to extract a specific code from a string, the number of numbers can vary. It should be quite easy, but I'm a bit new with regular expressions, the central idea here is in the Num column, isolate the numeric values of the IR variable.

I'm trying to build a formula, but I'm having trouble, I thought of something like this: REGEX_Replace ([Address], "[^ \\ d] * [\\ d] + [^ \\ d] + ([\\ d] +) "," "), but did not produce good results. Would anyone have another idea?

[Thableaus · Accepted solution]

Hi @Erike 

Here it is what you want (that's what I think so).

REGEX_Replace([Address], "\D+(\d+).*", "$1")

It basically captures the first occurrence of digits (1 or more).

Cheers,

[Erike]

Thableaus thanks man!!!!!