Forum Discussion

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Solved

Add Leading Zeros

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 ha...
transform
  • dwhansen-cbg's avatar
    dwhansen-cbg
    6 years ago

    Thank you @tstack! That worked!

PSAmmirata's avatar
PSAmmirata
Employee
6 years ago
Copy Link

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.