When we are dealing with Text formats in Anaplan it is case sensitive and it throws unexpected results if we don't do it exactly the way it should be.
Although we can achieve this by amalgamation of LOWER, UPPER, FIND, LEFT & RIGHT functions. Having PROPER function would greatly reduce the need to do so.
In case of titles for Anaplan, I would agree.
I wouldn't use proper to avoid case sensitivity issue; UPPER or LOWER is much better as it matches all characters.
What I meant by that was that we will have to use LEFT UPPER, RIGHT LOWER etc- all sort of amalgamation techniques. For example if I have to write "Master Anaplanner" - where only first letters are capital letters - Can't use UPPER or LOWER exclusively here without LEFT, RIGHT etc to do something that is close enough to PROPER function
Hi @Misbah , It makes sense whenever we wanted to check case sensitive also as part of our validations. It would be good to have the function from anaplan to support the ask.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.