In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parse based on a word in a field.

pranee_007
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.

2 REPLIES 2
OllieClarke
15 - Aurora
15 - Aurora

HI @pranee_007 

 

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

 


(ENTY.{11})

 

OllieClarke_0-1571842148108.png




 

NicholasM
Alteryx Alumni (Retired)

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
Top Solution Authors