HI,
I am using DS 8.7 Parallel version. I have a requirement like this.
my source is,
FirstName|Middlename|Lastname
john james|david|mcallister john
james|john|mcallister james
I want out put like below.
FirstName|Middlename|Lastname
John James|David|Mcallister John
James|John|Mcallister James
Starting character in every word should be in UPPER case.
Please help me out on this.
Thanks
Srinivas
converting lower case to upper case of first character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This can be done by using either CAPITALS transform or OConv(InLink.TheString,"MCT") in a "BASIC Transformer" stage.
In a parallel Transformer stage you could loop through the words in the string and capitalize them individually usingwhere lvTheWord is a loop variable containing
In a parallel Transformer stage you could loop through the words in the string and capitalize them individually using
Code: Select all
Upcase(lvTheWord[1,1]):lvTheWord[2,Len(lvTheWord)-1]
Code: Select all
Field(InLink.TheString, " ", @ITERATION, 1)
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.