Rpad in PX

[talk2shaanc]

Hi All,
a quick question. How to Right justify and zero fill; a string in PX?
An equivalent of FMT(ColumnName,"11'0'R"), in PX.
I was looking for functions, but couldnt find one. Px has PadString function, but it does Left justification.

[jtwilson]

Shantanu,

It's not very pretty but I use the following to concatenate to the left of an input column. Just switch the order of the concatenation to pad to the right.

Str("0",<<padlength>> - Len(<<input_column>>) ): <<input_column>>

John

[kumar_s]

If the input is numbers, Make is as decimal. By default 0s will be padded at left.
Or you can also use

Code: Select all

PadString(%string%,%padstring%,%padlength%)

. Again you need to follow Johns method to pad to left.

[talk2shaanc]

There is another way of doing it.

Right('00000000000':<link.column name>,11)