How to PAD with Leading Zeroes

[ambasta]

Hi All,
Can anyone please help me..
Source is having Varchar(10) and target is Char(10).My Requirement is...
any length of data till length 10 can come from source,and i need to pad this data with leading zeroes followed by that data so that length in target side is remain 10.
Ex.
if data is coming like 12345 then populate 0000012345,
if data is coming like 432 then populate it as 0000000432.
if data is coming like 1234567 then populate it as 0001234567.

Please help me.

[ArndW]

I can think of a couple of approaches in a transform stage using string functions.
One would be

Code: Select all

STR('0',10-Len(In.String)):In.String

or

Code: Select all

RIGHT('0000000000':In.String,10)

to name just two methods.

[meena]

Hi,
Try this FMT("input column", "10'0'R").

Source is having Varchar(10) and target is Char(10).My Requirement is...
any length of data till length 10 can come from source,and i need to pad this data with leading zeroes followed by that data so that length in target side is remain 10.
Ex.
if data is coming like 12345 then populate 0000012345,

[ambasta]

Thanx a lot ArndW for this kind help.
This is working for me.

[ray.wurlod]

Is FMT function available in parallel jobs?

[ambasta]

Hi Ray,
i can't find any function called FMT in parallel jobs.I think it is not available.