How to pad a string?

Hello there,

I would like to loop over several columns and rows automatically. I may have 250 columns and 7000 rows… some of the cells do have data, some don’t.

I read the post, Replace - PadLeft - KNIME Analytics Platform - KNIME Community Forum but I couldn’t tell how to loop it.

I was able to shorten the expression using < padLeft(column(“Col01”),12,“0”) > meaning, I want all cells to have 12 digits and the ones that do not, add a zero as a prefix.

Any help is appreciated. Thanks!
J.

Here’s what I am doing, but since I have 200+ columns, I am looking for an easier way