Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
urshit_1983
Participant
Posts: 73 Joined: Wed Jun 28, 2006 3:27 pm
Location: NJ
Post
by urshit_1983 » Tue Aug 15, 2006 12:06 pm
Hi Everybody,
I want to build a server routine which will give me output like:
Input Output
MEL GIBSON Mel Gibson
TIGER - WOODS Tiger - Woods
Please share your experience
Thnx.
"Nobody is expert in Everything,
But Everybody is expert in Something."
kris007
Charter Member
Posts: 1102 Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI
Post
by kris007 » Tue Aug 15, 2006 12:11 pm
There is a function called "DownCase" available which converts data in UpperCase or MixedCase into lowercase. You might want to use that function straight away in a Transformer Stage unless you are doing something else using this routine.
Kris
Where's the "Any" key?-Homer Simpson
urshit_1983
Participant
Posts: 73 Joined: Wed Jun 28, 2006 3:27 pm
Location: NJ
Post
by urshit_1983 » Tue Aug 15, 2006 12:13 pm
I dont simply want to down case the string. Please see my question:
I want the first letter of each word to be in Capital letters.
"Nobody is expert in Everything,
But Everybody is expert in Something."
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Aug 15, 2006 12:15 pm
There is a transform called CAPITALS which will do what you want.
-craig
"You can never have too many knives" -- Logan Nine Fingers
urshit_1983
Participant
Posts: 73 Joined: Wed Jun 28, 2006 3:27 pm
Location: NJ
Post
by urshit_1983 » Tue Aug 15, 2006 12:23 pm
Thnxs everybody. I got it
. I didnt knew there is inbuilt available. So was trying to build a routine. Trying to act smart unnecessarily
"Nobody is expert in Everything,
But Everybody is expert in Something."
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 15, 2006 11:23 pm
Tech Tip # 402
Become aware of what's available - doing so can prevent unnecessary re-invention of many different wheels!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
prabu
Participant
Posts: 146 Joined: Fri Oct 22, 2004 9:12 am
Post
by prabu » Wed Aug 16, 2006 1:42 am
ray.wurlod wrote: Tech Tip # 402
Become aware of what's available - doing so can prevent unnecessary re-invention of many different wheels! ...
Ray, do you have patent for these tech tips and is it published somewhere. On the lighther side, if weels have not been re-invented we would have struck with
[img]
http://patentpending.blogs.com/patent_p ... 154_pm.jpg
[/img]
regards,
Prabu