Hi Team,
I have a free text field whose values can be close to 200 characters. How to search for the word 'ENTY' and return the value ENTY and 11 characters after that in a new field appended to the old data.
Solved! Go to Solution.
Hey @Pranee_007 ,
@OllieClarke beat me too the punch. Regex is for sure the tool you'll be using to parse your data. I used the Regex String .*?ENTY(.{11}).*? to accomplish something similar. See photo below.
If you are new to Regex, I'd highly recommend checking out the website https://regex101.com/ for assistance.
Hope this helps!