heidi_andrew
3 years agoContributor
Pad field with zero
How can i take a sql result field where I am counting the number of people in the file for a trailer and left pad with zeroes? I have tried a bunch of the expressions shown in several of the answers here but nothing is working. I get
It is because the COUNT is an integer, try with this:
"0000000000".slice($COUNT.toString().length) + $COUNT