How to append leading or trailing zeroes to a number
Options
Sueann See
Experian Super Contributor
Aperture makes it very easy for you to append a chosen character to any value to achieve an overall length. You also have the option to add the character at the beginning or at the end.
To achieve this, look for the Pad function that you can use within a Transform step.
Example 1: To add leading zeroes to the value "1" in order to achieve a 5 characters length, the settings is as follows:
Example 1: To add trailing zeroes to the value "1" in order to achieve a 5 characters length, you will have to check on "Align left"
1
Categories
- All categories
- 17 Get started
- 484 Get involved
- 18 Support
- 254 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 97 Community categories