Parsing number within words

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

Parse

Accepted answers

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

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

You could use REGEX in the Formula Tool.

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

Cheers,

It was that simple, thank you!!