add leading space and leading zeros
Posted: Thu Jan 27, 2011 5:56 am
Hi,
I want all my output fields should be Right aligned.
Eg 1: If my input field: Col1, data type: Char(4), field value:+1
My output should be: +1 (2 leading spaces then field value)
Eg 2: If my input field: Col2, data type: integer(4), field value:10
My output should be:0010 (2 leading zeros then field value)
Kindly help me to resolve it.
Regards,
I want all my output fields should be Right aligned.
Eg 1: If my input field: Col1, data type: Char(4), field value:+1
My output should be: +1 (2 leading spaces then field value)
Eg 2: If my input field: Col2, data type: integer(4), field value:10
My output should be:0010 (2 leading zeros then field value)
Kindly help me to resolve it.
Regards,