How to convert the first letter of each word to UPPERcase in OBIEE 11g

2881099

How to convert the first letter of each word to UPPERcase in OBIEE 11g

Not by using the Evaluate.

Requirement: I need the data in my column("Country"."Country Name") as below

UNITED STATES OF AMERICA -> United States Of America

[Deleted User]

So you can't simply INITCAP in an EVALUATE? Not even in the RPD where end users can't touch it? Because writing this manually in a column formula is ugly - no matter whether you do it in the RPD or in Answers.

2881099

I'm looking for a quick solutions to do it in answers, I don't have access to rpd access

and evaluate is disabled at movement in our environment.

I'll request my IT team to enabled which takes for ever so just posted to see if any one could help me with quick sol.

like I'm using this

SUBSTRING("Country"."Country_Name" FROM 1 FOR 1)|| LOWER(SUBSTRING("Country"."Country_Name" FROM 2))

but this only gives the complete string not the first letter of each word

[Deleted User]

Yes because that's not initcap-ing words, that's initcap-ing whole strings.

There's a reason that this is done in actual DB functions and that almost all sources have something like this: it's ugly to re-invent the wheel and write that code yourself