Forum Discussion

heidi_andrew's avatar
heidi_andrew
Contributor
3 years ago
Solved

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 ...
  • Aleksandar_A's avatar
    Aleksandar_A
    3 years ago

    It is because the COUNT is an integer, try with this:

    "0000000000".slice($COUNT.toString().length) + $COUNT
Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago
Copy LinkReport

Hi @heidi.andrew,

You can try with the following expression:

"0000000000".slice($COUNT.length) + $COUNT

Let me know if this helps you.

BR,
Aleksandar.

heidi_andrew's avatar
heidi_andrew
Contributor
3 years ago
Copy LinkReport

I KEEP getting the null:


But i did figure out how to show first day of last month and last day of last month!

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    3 years ago
    Copy LinkReport

    It is because the COUNT is an integer, try with this:

    "0000000000".slice($COUNT.toString().length) + $COUNT