Add Leading Zeros

[dwhansen-cbg]

I have strings that are storing a two digit number (i.e. 00, 01, 02, etc) but I need to add another leading zero (i.e. 000, 001, 002). I don’t want to simply concatenate a 0 on the front in case I have values that end up being three digits.

[christwr]

Should be doable with sprintf() string function.

[PSAmmirata]

This worked well. I was padding a string with spaces. Beware that when I validated the pipeline the string in the preview data was not displayed with the padding, but the string was actually padded as expected.

[dwhansen-cbg]

$value = “01”.
I’ve tried $value.sprintf(“%03d”, “0”) and several other similar things but it doesn’t seem to work.

[tstack]

It looks like the format and the value to format are switched around. The sprintf() method is to be called on the format string, like so:

"%03d".sprintf(parseInt($value))

Note that the value passed in needs to be a number and not a string, which is why I used parseInt().