Replace ID and add extra characters

Hello All,

I've a list of the test ID's that are available in the attached workflow, which is getting generated automatically.

so the requirement is Test ID should be formatted as ‘TI’ + ‘XXX’, where XXX is 3 digit integer. Tool is currently excluding leading zeros. Eg I am seeing ‘TI2’ instead of ‘TI002

and if it's 12th record it should show as 'TI012'.

Could you please advise how to format these ID's

Please find my workflow in the attachment

BR

swapsingh2712

Replace Test ID.yxmd

Preparation

Accepted answers

Hi @swapsingh2712

Us this formula

'TI'+PadLeft([Max_TEST_ID],3,"0")

Hope this helps : )

Replace Test ID.yxmd

All comments

Hi @swapsingh2712

Us this formula

'TI'+PadLeft([Max_TEST_ID],3,"0")

Hope this helps : )

Replace Test ID.yxmd

@swapsingh2712 updated your workflow

Replace Test ID.yxmd

Happy to help : ) @swapsingh2712

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703