Text String Extraction
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi There,
I have a request where i need to extract the quarter details from the description column..
Trouble is this information is only on certain rows and folks put this information in different places in the description string and use different formats such as Q3-2024 or Q4/24
As you see in RED below, this is what i need to extract.
In Green below, it shows you what i need....each description field is searched and a new column is created to show where quarter values have been found...
BEFORE 
AFTER
Any help would be great :)
Solved! Go to Solution.
- Labels:
- Data Investigation
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for taking time out to help me......this works perfectly :)
The RegEx is something i not good on...so needed this help :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DelData no worries. If you have any questions about it, feel free to ask.
I actually learned regex by following these lessons: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...
They're interactive and super useful.
I'd recommend this website for learning: https://regex101.com/r/E95Yq9/1
I've pasted your data in there, you can actually see the match with colours which helps you spot if you made the correct Regular Expression or not.
All the best,
BS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you....these links will help and look great.... :)