Parsing number within words

[swhitmeyer]

Hi,

I am looking to separate out any % within a field, see below.

D - JOINT AND 50% SURVIVOR         I would just want the 50

K - JOINT AND 75% SURVIVOR          I would just want the 75

6 - JOINT SURVIVOR POPUP 55%     I would just want the 55

Thank you,

Sonya

[JosephSerpis · Accepted solution]

Hi @swhitmeyer you want to use the regex tool with this syntax (\d{2})

[Thableaus]

Hi @swhitmeyer 

You could use REGEX in the Formula Tool.

REGEX_Replace([Field1], ".*?\b(\d.*)%.*", "$1")

Cheers,

[swhitmeyer]

It was that simple, thank you!!