Page 1 of 1
Title Case in Parallel
Posted: Mon Oct 15, 2007 5:25 am
by SURA
Hi,
Is there is any direct function to do Titel Case in Parallel Extender? If so pls let me know.
Eg:
Input
------
Hi how are you.
Expected Output
-------------------
Hi How Are You.
Ram
Posted: Mon Oct 15, 2007 5:38 am
by ArndW
The EE Engine doesn't have such a function. If performance is not a consideration then you can use a BASIC transformer stage in your job and do the conversion with OCONV(In.Column,'MCN'). Either that or write your own c++ function to do the initial caps and call that.
Posted: Mon Oct 15, 2007 8:42 am
by ray.wurlod
Arnd meant "MCT", or you could use the CAPITALS Transform (which does the same thing), in a BASIC Transformer stage.
Posted: Mon Oct 15, 2007 3:17 pm
by ArndW
I guess I did mean MCT. I wasn't sure which conversion it was, lacking the manuals, and actually had MCP down until I remembered that it didn't do what the poster requested.
Posted: Mon Oct 15, 2007 3:32 pm
by NBALA
If you use Oracle you can use the 'initcap' function
SQL> SELECT INITCAP('YOU TODAY') AS INIT_CAP FROM Dual;
INIT_CAP
---------
You Today
How Do I use the CAPITALS tranform for Case Conversion
Posted: Thu May 28, 2009 10:35 am
by janreddy
Hi, I see a built-in transform CAPITALS is available under Transform/Built-In/String that converts a string to word-initial capitals. but how I do use CAPITALS built-in transform that convert the first letter of each to uppercase and remaining string to lower case.
I am unable to drag and drop this transform or I am missing something.
could you briefly explain how I can use this in DataStage Parallel job flow.
Thanks
Jana
Posted: Thu May 28, 2009 10:40 am
by Sainath.Srinivasan
There was a C++ routine which Priyadharshi wrote. Search.