hi! i've been trying to find something similar in the discussion but have not been successful. im playing with the regex replace formula tool and want to see if i can only get the middle part of a string.
for example remove the 'DEF'
sample data | output data |
ABCDEFG | ABCG |
ABCDEFGH | ABCGH |
ABCDEFGHI | ABCGHI |
thank you
Solved! Go to Solution.
hi @atcodedog05 - this is the formula i wrote and giving a null.
REGEX_Replace([Field1], "\w{3}*(\w*)", " ")
@atcodedog05 that worked!
Happy to help : ) @utsarunner981
Cheers and have a nice day!