Server Routine

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

Post Reply
urshit_1983
Participant
Posts: 73
Joined: Wed Jun 28, 2006 3:27 pm
Location: NJ

Server Routine

Post by urshit_1983 »

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
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

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 »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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 »

Thnxs everybody. I got it :idea: . I didnt knew there is inbuilt available. So was trying to build a routine. Trying to act smart unnecessarily 8)
"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 »

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 »

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]


:lol: :lol:

regards,
Prabu
Post Reply