LOOP ADDING VALUE TO ID(validationID)

[Ran]

hi

 i have field  "ID"  with 5-9 digits

i need to  that all ID to be 9 digits

and to add "0" to the 5-8 digits

example 

ID

123456789 -> 123456789

12345->000012345

1234567->001234567

after that i need to make more calcuation that check if ID is vaild/invaild

thanks!

[Taoufiq_Zarra · Accepted solution]

@Ran  you can use this expression :

repeat('0',9-len(ID))&ID as New_ID

example :

DATA:
load *,repeat('0',9-len(ID))&ID as New_ID inline [
ID
123456789
12345
1234567
];

output:

[Ran]

Thanks😄