So you can't simply INITCAP in an EVALUATE? Not even in the RPD where end users can't touch it? Because writing this manually in a column formula is ugly - no matter whether you do it in the RPD or in Answers.
I'm looking for a quick solutions to do it in answers, I don't have access to rpd access
and evaluate is disabled at movement in our environment.
I'll request my IT team to enabled which takes for ever so just posted to see if any one could help me with quick sol.
like I'm using this
SUBSTRING("Country"."Country_Name" FROM 1 FOR 1)|| LOWER(SUBSTRING("Country"."Country_Name" FROM 2))
but this only gives the complete string not the first letter of each word
Yes because that's not initcap-ing words, that's initcap-ing whole strings.
There's a reason that this is done in actual DB functions and that almost all sources have something like this: it's ugly to re-invent the wheel and write that code yourself