How to remove Letters at the end of a string?

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

Community

Accepted answers

Emmanuel_G

Hi @Sriram_ts03 ,

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

Remove letters at end of string.yxmd

All comments

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.

New Workflow3.yxmd

Emmanuel_G

Hi @Sriram_ts03 ,

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

Remove letters at end of string.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703