Remove a Specific Character at the End

[KamenRider]

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

[atcodedog05 · Accepted solution]

Hi @KamenRider 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs]

@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 @binuacs, both solutions work.

Appreciate your response so much.

Kamen

[atcodedog05]

Happy to help : ) @KamenRider 

Cheers and have a nice day!