Title Case in Parallel

[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

[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.

[ray.wurlod]

Arnd meant "MCT", or you could use the CAPITALS Transform (which does the same thing), in a BASIC Transformer stage.

[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.

[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

[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

[Sainath.Srinivasan]

There was a C++ routine which Priyadharshi wrote. Search.