PROPER() Functionality

PROPER() Functionality

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.

4 Comments
Certified Master Anaplanner

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.

Master Anaplanner/Community Boss

@ablack 

 

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

 

Thanks,

Misbah

 

 

Community Manager
 
Status changed to: Your support is needed
Certified Master Anaplanner

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.

Users Online
Currently online: 293 members 745 guests
Please welcome our newest community members: