Oracle Analytics Cloud and Server Idea Lab

Add INITCAP/PROPER string function

Submitted
93
Views
0
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Oracle

Description (Required): Add a new string function that works like SQL INITCAP. Like Excel PROPER.

Use Case and Business Need (Required): Many use cases where showing a string with the first letter of each word as upper case is needed. Can include report titles, names, etc.. Database values are commonly stored as all upper or all lower cases but proper case provides a more professional view. There is a workaround using EVALUATE but given the many times proper case is needed, a built-in function is much more desirable.


Enhancement Request / Service Request:

3
3 votes

Submitted · Last Updated