topic Re: How to add text and number zero's to ID number in App Development

How to add text and number zero's to ID number

Sra1bandi — Fri, 20 May 2022 06:20:17 GMT

Hi Team,

I have ID numbers

2000

i want to show it as

Before id i have to add Text as TNN00000

For example:- ID 1 ====> show as ====> TNN000001

ID 2 ==================> TNN000002

ID 10 =================> TNN000010

ID 111================> TNN000111

ID 1213================> TNN001213

IF the digits increased then we have to decrease the Zeros

after TNN required six Numbers

I have to show in ID value digit's increases then the zeros have to decreased as shown in the above example

Thanks & Regards,

Sravan

Lisa_P — Fri, 20 May 2022 06:48:09 GMT

Load using this:

'TNN'&Num(ID, '000000') as TNNID

vinieme12 — Fri, 20 May 2022 08:49:49 GMT

you can take this a step further

Num(ID, 'TNN000000')

Sra1bandi — Fri, 20 May 2022 09:52:09 GMT

Thanks to both of you