Hi All
Can you pls advise how to remove the last two characters from this no
Example:
ABC0000005709859-2
i have to remove - and numbers appear as last
kindly advise ,thanks in advance
Hi @nayrah
One way of doing this is with the help of Regex tool.
Regular expression
(\d+)(-\d+)
Output method: Replace
Replacement Text: $1
Note: By using this method, it will help to trim the last 2 digits only when it contains '-'
Many thanks
Shanker V