format string

sainath · Post by **sainath** » Sun Apr 16, 2006 10:10 am

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

meena · Post by **meena** » Sun Apr 16, 2006 10:40 am

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

ArndW · Post by **ArndW** » Sun Apr 16, 2006 10:52 am

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

chulett · Post by **chulett** » Sun Apr 16, 2006 12:47 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sun Apr 16, 2006 3:16 pm

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

chulett · Post by **chulett** » Sun Apr 16, 2006 4:24 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 17, 2006 12:39 am

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.