Parse based on a word in a field.

[Pranee_007]

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.

[OllieClarke]

HI @Pranee_007 

Use a RegEx tool in Parse mode and the following formula:

---

(ENTY.{11})

---

[NicholasM · Accepted 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!