Need to ad INITCAP function to available functions

Martin_Gibbs_Mayo

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.

Bret Grinslade - Oracle Analytics-Oracle

@MGibbs_2023 — if this were an option in the dataset editor — is that sufficient?

@Luis E. Rivas -Oracle This seems useful.

Luis E. Rivas -Oracle

@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.

Gabby Rubin-Oracle

If your data is in Oracle DB you can do:
evaluate('Initcap(%1)',Employee."First Name")

Benjamin Arnulf-Oracle

@Martin_Gibbs_Mayo Please could you comment if the above solution is helping. I will close this request.