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. ColumnDesired columnABC_raw_dataABCXYZ 1Q_raw_dataXYZXYZ_raw_dataXYZDEF INTERNATIONAL Q1_raw_dataDEF INTERNATIONALDEF INTERNATIONAL Q2_raw_dataDEF INTERNATIONALKLS HOLDING H1_raw_dataKLS HOLDINGKGS H1_raw_dataKGS

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

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

Workflow

Accepted answers

atcodedog05

Hi @acaryasin01

Here is how you can do it.

Formula:

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

Workflow:

Hope this helps : )

XYZ.yxmd

All comments

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.

Trim.yxmd

atcodedog05

Hi @acaryasin01

Here is how you can do it.

Formula:

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

Workflow:

Hope this helps : )

XYZ.yxmd

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?

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703