Hi,
We use Report Studio 8.3
We need to format a String type column in our list.
The column has 5 to 7 characters.
We want to format the column in order to ADD "zeros" when less than 7 characters.
For example:
12345
would become
0012345
Is this possible and how ?
Thanks !
just a semantic difference, that's not "adding" it's called concatenating.
...and in this circumstance it's called "padding":
if you're using Oracle, the function you're looking for is called: "LPAD".