Forum Discussion

Tatynout's avatar
Tatynout
Copper Contributor
Oct 11, 2019
Solved

Transformation of values' lenght in a field based on the number of caracters

Hello,

I would like to add a new field by applying a condition on data values from my Vendor field. I want to set each values in that field so they all have 10 characters and to do so i want to apply a condition in such a way that if the value's lenght is smaller than 10 then 0 should be added in front of the value until it makes 10 characters.

For Example:

Vendor
0045676
000034567
76890650
2340987653

 

I should get the following results:

Vendor
0000045676
0000034567
0076890650
2340987653

 

Thanks for your help.

Regards,

Tatiana

Resources