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
Solved! Go to Solution.
Hi @swhitmeyer
You could use REGEX in the Formula Tool.
REGEX_Replace([Field1], ".*?\b(\d.*)%.*", "$1")
Cheers,
It was that simple, thank you!!