REGEX TOOL - REPLACE METHOD

[Tommy_Alterax]

Hi Guys,

 I want to use the REGEX TOOL replace function - I want it to review my sample column of data - In the same Column I want to remove all no numeric characters so i am only left with a number

 For example below "PIA" will be removed as will "*"  ----- There is no exact length of digits - The example below shows digits of 4 in length however, could be shorter longer

[OllieClarke]

Hi @Tommy_Alterax the following Regex will replace anything which isn't a number

REGEX_REPLACE([Field],'\D','')

Or in the regex tool just put '\D' in the regex box and leave the replacement box empty

Hope that helps,

Ollie

[Tommy_Alterax]

Hi Ollie,

I'm specifically looking for the configuration of the Reg Ex tool replace option (not the formuale tool) - I couldnt get it working with your note on Reg Ex tool

Regards,

             Tommy

[Qiu]

@Tommy_Alterax 

It is basically same idea as proposed by @OllieClarke