Oct 11 2019 05:13 AM
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
Oct 11 2019 06:02 AM
SolutionOct 11 2019 08:25 AM
@Sergei Baklan Thank you!
Oct 11 2019 08:42 AM
@Tatynout , you are welcome
Oct 11 2019 06:02 AM
Solution