InitCap without Evaluate

Rob F

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?

Rick Brobbel

Hi,

You may try the function UPPER. Use this on the first character only and the concatenate with the rest of the string.

Something like: UPPER(LEFT(Name,1) || SUBSTRING(Name,2,99)

99 is the rest of the string. You can use LENGTH or something like that instead.

Good luck

RichardChan

Upper(left(string,1))||lower(subst(string,2,length(string)-1) or something similar not sure of exact syntax but you get the idea