Hello Community,
I would like to add trailing zeros in front of a value, but only display 5 characters for the value. In addition, I would want to add a prefix of "ABC-". I have no issue with the prefix, but the zeros I would need assistance. I could add 4 zeros in front of the value and then trim the value for displaying last 5 characters, but I wanted to see the cleanest way to accomplish. Examples below.
Value = 876
I would like the new value to be ABC-00875.
Value = 1678
I would like the new value to be ABC-01678.
Value = 5
I would like the new value to be ABC-00005.
Thanks,
Joe
Try the printf function.
| eval Value=printf("ABC-%05d", Value)
Try the printf function.
| eval Value=printf("ABC-%05d", Value)
Thank you. Short and nice. 🙂