SOLVED
Parse based on a word in a field.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
pranee_007
7 - Meteor
‎10-23-2019
07:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Parse
2 REPLIES 2
15 - Aurora
‎10-23-2019
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
NicholasM
Alteryx Alumni (Retired)
‎10-23-2019
07:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
