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.
Thank you for taking time out to help me......this works perfectly :)
The RegEx is something i not good on...so needed this help :)
@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
Thank you....these links will help and look great.... :)
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |