DSXchange

hi
I want to take last 10 char from a input string and add 00000 before it to make 15 character length.i just appendbed 00000:input column.is there any better way.
thks
sai

Hi Sai,
You can write a stage varaible for this. There are fuctions avaible in the tranformer. Use the "substr" function to extract the wanted string from the input stream and use the fmt to pad the string with the zero's and can make the total length 15. Hope this helps you. Even I am new to DS. Try this

Meena

You can use the derivation fmt(right(In.Column,10):"00000","15'0'R") to do what you asked.

Try just fmt(right(In.Column,10),"15'0'R") as it looks like Arnd misunderstood the 'tacking on five zeroes' part.

Well, one of the two of us did.

If Sainath has ten characters (guaranteed) from the input stream, then concatenation ("00000" : InLink.C10column) is the most efficient algorithm.

Agreed, but the FMT solution seems... better. At least from an educational standpoint.

For some folks "performance" (whatever that means) is the primary goal. It's always beneficial to know the most efficient techniques, particularly for large to huge data volumes.