Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Need to ad INITCAP function to available functions
Martin_Gibbs_Mayo
Rank 2 - Community Beginner
We have several database columns that are saved in UPPERCASE. End users would prefer to see the data in proper case on reports and dashboards. Please add the INITCAP function to the String functions available in OAC.
Tagged:
5
Comments
-
@MGibbs_2023 — if this were an option in the dataset editor — is that sufficient?
@Luis E. Rivas -Oracle This seems useful.0 -
@MGibbs_2023 I agree adding Initcap would be a useful addition for case handling. In the meantime, Sentence case may be a good workaround for now, it will uppercase the first word in the text and lowercase all others.
0 -
If your data is in Oracle DB you can do:
evaluate('Initcap(%1)',Employee."First Name")2 -
@Martin_Gibbs_Mayo Please could you comment if the above solution is helping. I will close this request.
0
