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
format string
Moderators: chulett, rschirm, roy
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 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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.