How to trim last two dgits

Question

Hello,

I am looking to trim the last digits of "ID" column, Can anyone assist on this

IDExpected output555552555555170123517012170124517012280129928012280124928012555553555555

aatalai · Answer

Agreed with @ShankerV there are many ways. I've attached a workflow that is slightly more dynamic, i.e will work if the column length is not 7. Let me know how you get on

How to trim last two dgits.yxmd

ShankerV · Answer

Hi @Saravanan13

There are many ways to achieve this output.

In the formula tool, use the below

Left(tostring([ID]),5)

Note: Assumption made that the ID column length is 7