converting lower case to upper case of first character

[srini27]

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

[rkashyap]

This can be done by using either CAPITALS function or OCONV({Instring},'MCN') in a "Basic Transformer".

[mobashshar]

What have you tried so far?

[ray.wurlod]

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 using

Code: Select all

Upcase(lvTheWord[1,1]):lvTheWord[2,Len(lvTheWord)-1]

where lvTheWord is a loop variable containing

Code: Select all

Field(InLink.TheString, " ", @ITERATION, 1)