Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Parse based on a word in a field.

Highlighted
7 - Meteor

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.

Highlighted
Alteryx Certified Partner

HI @Pranee_007 

 

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

 


(ENTY.{11})

 

OllieClarke_0-1571842148108.png




 

Highlighted
Alteryx
Alteryx

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. 

 

Capture.PNG 

 

Hope this helps!

Labels