How to remove Letters at the end of a string?

[Sriram_ts03]

Hello Community -

Please help me with the below scenario.

I would like to get character(letters) removed at the end of a string. If i use Data cleansing tool, it removed the letters in between the string as well.

Input                        Output

2102CX746OT       2102CX746

2163BD5120A        2163BD5120

Thnx

[Amol_Telore]

Hey @Sriram_ts03 

Here is my solution. 

I have used regex to exclude any letters occurring at the end of the string. Hope this solves your issue.

[Emmanuel_G · Accepted solution]

Hi @Sriram_ts03 ,

Find attached two more ways to do this : With and without regex formula.

[Alteryx_AR]

Hey @Sriram_ts03  - Another solution is below. Use substring function. 

Hope this helps you :). 

[Sriram_ts03]

Thank you all for the solution. Appreciated.