Remove last 2 digit from the column

[nayrah]

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

[binuacs]

@nayrah 

[ShankerV]

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

[aatalai]

You could also us the formula tool like so

Left([Data], Length([Data])-2)