Forum Discussion
Tatynout
Oct 11, 2019Copper Contributor
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
3 Replies
- SergeiBaklanDiamond Contributor
- TatynoutCopper Contributor
SergeiBaklan Thank you!
- SergeiBaklanDiamond Contributor
Tatynout , you are welcome