Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 314 Oracle Analytics and AI News
- 58 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need to ad INITCAP function to available functions
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.
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 -
@Benjamin Arnulf-Oracle and @Gabby Rubin-Oracle , while the EVALUATE workaround works, but it comes with a SQL Injection Risk and hence EVALUATE is not permitted by a lot of customers. Having a native INITCAP function would make this a clean approach rather than writiing complicated Substrings and Upper/lower concatenations.
0
