SOLVED
How to remove Letters at the end of a string?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sriram_ts03
5 - Atom
‎08-21-2022
02:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Community
4 REPLIES 4
Amol_Telore
11 - Bolide
‎08-21-2022
02:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
13 - Pulsar
‎08-21-2022
04:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx_AR
12 - Quasar
‎08-25-2022
07:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-25-2022
07:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all for the solution. Appreciated.