Hi guys,
I have date colum include companys' name + "_raw_data" + Q1 or Q2 or H1.
How can I get rid of the "_raw_data" + Q1 or Q2 or H1.
Here is colummn and desired column example.
Column | Desired column |
ABC_raw_data | ABC |
XYZ 1Q_raw_data | XYZ |
XYZ_raw_data | XYZ |
DEF INTERNATIONAL Q1_raw_data | DEF INTERNATIONAL |
DEF INTERNATIONAL Q2_raw_data | DEF INTERNATIONAL |
KLS HOLDING H1_raw_data | KLS HOLDING |
KGS H1_raw_data | KGS |
Solved! Go to Solution.
Hi @acaryasin01
Here is how you can do it.
Formula:
REGEX_Replace(Replace([Column], "_raw", " "), "([\u\s]+)\s(.*)", "$1")
Workflow:
Hope this helps : )
Hi @Christina_H
This solution also works, but my workflow is more complex, buecause of that regex is more usefull for my workflow
Thank you for your time and respond, appriciated 😊
Hi @atcodedog05
Thank you for detailed answer, excellent 👍👌
I think, Regex is an another world, how can translate regex expression to daily talk,
have you any sources to understand insight of regex?
Hi @acaryasin01
I personally learnt some from the resources but a lot from other people's approaches. I am still a continuous learner when it comes to Regex. Here are some resources which might help you.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689
Happy to help : )
Cheers and have a nice day!
Thank you @atcodedog05 for sharing useful and important info
Congratulations for your being humbe 👏👏👏
Hello,
Could I ask if using the Regex_Replace help in removing three different text like "Primary Owner", "Primary Owner - Auto" and "Second Owner" or should I use if function? I would be grateful for any idea. Thank you. :)