How to trim last two dgits

[Saravanan13]

Hello,

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

ID	Expected output
5555525	55555
1701235	17012
1701245	17012
2801299	28012
2801249	28012
5555535	55555

[ShankerV]

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

[aatalai]

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