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
Initcaps
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
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..
CAPITALS(%Arg1%)
but again it's a BASIC transformer being used in a PX job..
Last edited by Nripendra Chand on Thu Mar 20, 2008 4:41 am, edited 1 time in total.
-Nripendra Chand
I just realized I mis-typed the function, the correct one is "OCONV(In.ColumnName,"MCT")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>