Text String Extraction

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

before.png

after.png

quarter value get.xlsx

Preparation

Data Investigation

Accepted answers

BS_THE_ANALYST

@DelData Regex is likely a good solution here:

The regex:

(Q[^a-zA-Z ]+)

Says, if you're the letter Q and you're followed by characters that are not letters or spaces, extract that joined set of characters.

Hope that helps!

All the best,

textParsing.yxmd

All comments

BS_THE_ANALYST

@DelData Regex is likely a good solution here:

The regex:

(Q[^a-zA-Z ]+)

Says, if you're the letter Q and you're followed by characters that are not letters or spaces, extract that joined set of characters.

Hope that helps!

All the best,

textParsing.yxmd

DelData

Thank you for taking time out to help me......this works perfectly

The RegEx is something i not good on...so needed this help

BS_THE_ANALYST

@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%20Data

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,

DelData

Thank you....these links will help and look great....

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703