Oracle Transactional Business Intelligence

Products Banner

InitCap without Evaluate

33
Views
2
Comments

Summary

Trying to arrive at "normal" case for names without Evaluate function

Content

Names in our system are entered inconsistently and the goal is to be consistent with the casing. I've seen references to using EVALUATE('initcap(%1)', Table.ColumnName) to change the casing to normal casing but I've also learned that the Evaluate function was inactivated for Fusion SaaS customers. (Support doc: Doc ID 1922648.1 )

Is there any other solution to fixing the casing on the names without the evaluate function?

Tagged:

Comments