Case sensitivity

Aditya1993
New Contributor

Case sensitivity

Hi 

 

In one of my project i need to check whether the opportunity name already been used or not with Boolean but Anaplan is not considering the case sensitivity. For Ex: if the opportunity name in Apple and user comes in and input apple(with no capital A) Anaplan is recording it as a unique name. Ideally it should flag for the duplication.

 

I user UPPER and LOWER for all the opportunity but for the opportunity with 2 words make lot of combination which is hard to consider.

Let me know if there is any solution.

1 ACCEPTED SOLUTION

Accepted Solutions
anand.shekhawat
Super Contributor

Re: Case sensitivity

@Aditya1993 

 

Convert both the texts that you want to compare either in lower case or uppercase, and then you can compare the same. Follow the below snip.

anandshekhawat_0-1633521764642.png

 

~Anand

View solution in original post

1 REPLY 1
anand.shekhawat
Super Contributor

Re: Case sensitivity

@Aditya1993 

 

Convert both the texts that you want to compare either in lower case or uppercase, and then you can compare the same. Follow the below snip.

anandshekhawat_0-1633521764642.png

 

~Anand

View solution in original post