LPAD equivalent in DS

rxs0005 · Post by **rxs0005** » Fri Nov 04, 2005 11:05 am

hi all

All i need to do is i have a column that is 5 characters long .

I need to LPAD it with 0's if its not 5 characters long

Input col = ABCD OUTPUT = 0ABCD

Input col = ijklm OUTPUT = ijklm

basically the oracle LPAD equivalent .

I found the

PadString function
Return the string padded with the optional pad character and optional length
string (string)
padlength (int32)
result (string)

but i cannot find it in the trasnfomer when i do the right click so i dont knwo what the input parameters are

thanks
rxs0005

ArndW · Post by **ArndW** » Fri Nov 04, 2005 11:09 am

The function/derivation you are looking for is FMT(In.Column,'5"0"R')

rxs0005 · Post by **rxs0005** » Fri Nov 04, 2005 12:14 pm

thanks that worked!

ray.wurlod · Post by **ray.wurlod** » Fri Nov 04, 2005 3:34 pm

It can also be represented as Fmt(InLink.Column, "R%5")

Marley777 · Post by **Marley777** » Tue Oct 23, 2007 1:28 pm

Hi, how do you do this on in a DataStage PX 7.5 job? Thanks!!

ray.wurlod · Post by **ray.wurlod** » Tue Oct 23, 2007 3:28 pm

Why didn't you ask in the parallel forum?

Assuming you have a string data type you would use something like

Code: Select all

Left("00000",5-Len(InLink.TheString)) : InLink.TheString

If the incoming data type is not string, you would need to convert it to string.