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.
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.
Thank you all for the solution. Appreciated.