InitCap in Transformer

[vick]

Hello,

I want to do an initcap on a particular column in transformer.

I m doing it using CONVERT function for columns that has fixed values

For instance

Code: Select all

in.Col  has fixed values like 'web number'

CONVERT ("wn", "WN", in.col)

How do I go about for columns whose values are not fixed?

Pl suggest

TIA

[ray.wurlod]

There's nothing out of the box, but it would be a fairly straightforward parallel routine to write.

Consider your business rules, though. InitCap might also need to occur after certain other characters, like O'Brien or Sarbanes-Oxley.

Then there are the exceptions, such as fforbes-Hamilton, MacDonald or "de Gaulle".

What level of complexity do you require?

[DSguru2B]

Vick, yet again there is a need for a C routine

[gsym]

Thanks

[DSguru2B]

Psst....no hijacking It will depend upon the complexity, as Ray mentioned.