Initcaps

ankita · Post by **ankita** » Thu Mar 20, 2008 3:22 am

Hi All,
There is a requirement to change the first char of every word into Uppercase. Say i/p test is : willilam smith

O/p should be : William Smith

No. of words in the input string may vary. Is there any easy way to do this ? other than extracting first char of each word separately ? Please suggest.

Thanks,
Ankita

Nripendra Chand · Post by **Nripendra Chand** » Thu Mar 20, 2008 3:56 am

when no of words dynamic then you can write a parallel routine and pass input column and no of words as two arguments to it.

ArndW · Post by **ArndW** » Thu Mar 20, 2008 4:29 am

There is no builtin function in PX to do this. If you can write this portion of your processing in Server, then you can use the function OCONV(In.Column,"MCN") to perform this conversion for you.

Nripendra Chand · Post by **Nripendra Chand** » Thu Mar 20, 2008 4:30 am

one more option.. u can use Basic transformer and use CAPITALS fn to do this as follows:
CAPITALS(%Arg1%)

but again it's a BASIC transformer being used in a PX job..

ankita · Post by **ankita** » Thu Mar 20, 2008 4:40 am

Thanks for your suggestions ! I will try with basic transformer .

ArndW · Post by **ArndW** » Thu Mar 20, 2008 5:02 am

I just realized I mis-typed the function, the correct one is "OCONV(In.ColumnName,"MCT")

chulett · Post by **chulett** » Thu Mar 20, 2008 7:39 am

ps. CAPITALS and Arnd's specific OConv function call are the same thing, as the CAPITALS transform just does the function call for you. Without any mis-typing.