How to get rid of multiple and different characters in a column

[acaryasin01]

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

[Christina_H]

Here's my quick take on this - using find/replace to replace the strings you don't want with spaces, then data cleansing to remove trailing spaces.

[atcodedog05 · Accepted solution]

Hi @acaryasin01 

Here is how you can do it.

Formula:

REGEX_Replace(Replace([Column], "_raw", " "), "([\u\s]+)\s(.*)", "$1")

Workflow:

Hope this helps : )

[acaryasin01]

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 😊

[acaryasin01]

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?

[atcodedog05]

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://regexr.com/

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689 

Happy to help : )

Cheers and have a nice day!

[acaryasin01]

Thank you @atcodedog05  for sharing useful and important info

Congratulations for your being humbe 👏👏👏

[Agaton]

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. :)