Remove a Specific Character at the End

Hi,

I would like to seek you help on how I am going to remove a specific letters at the end of an ID number. The specific letters are _R, _OT and _OTR. For example if I have 123456789_R, the results should be 123456789.

Attaching the data for your reference.

Thanks and looking forward for your assistance.

Kamen

Get Rid of OT-OTR-R.yxmd

Workflow

Output

Common Use Cases

Accepted answers

atcodedog05

Hi @KamenRider

Here is how you can do it.

Workflow:

Hope this helps : )

Get Rid of OT-OTR-R.yxmd

All comments

atcodedog05

Hi @KamenRider

Here is how you can do it.

Workflow:

Hope this helps : )

Get Rid of OT-OTR-R.yxmd

binu_acs

@KamenRider

IIF(EndsWith([ID Number], '_R') OR EndsWith([ID Number], '_OT') OR EndsWith([ID Number], '_OTR'),REGEX_Replace([ID Number],'(.+)_(.+)', '$1'),[ID Number])

KamenRider

Thank you guys @atcodedog05 and @binu_acs, both solutions work.

Appreciate your response so much.

Kamen

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317