Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to convert the first letter of each word to UPPERcase in OBIEE 11g
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
Answers
-
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.
0 -
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
0 -
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
0