Compare two text withouth case sensitive

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi at all,
I've created a formula
IF({{Telefono}}=={{$Model.Pratica.data.0.Azienda__r.Phone}},"","!")

It's working fine but I want It case insensitive. 
Any idea?
Thank you
Photo of Andrea

Andrea

  • 460 Points 250 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Andrea,

Add UPPER() to both sides of your comparison.  This should get you what you want.

IF(UPPER({{Telefono}}==UPPER({{$Model.Pratica.data.0.Azienda__r.Phone}}),"","!")

Thanks,

Bill
Photo of Andrea

Andrea

  • 460 Points 250 badge 2x thumb
Thank you Bill!!
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
Very helpful, thanks Bill! It would be great for Skuid to add this to the function menu (Are there any Skuids Listening???)
-Disregard... I see it in there now, but it brings up another issue, I am unable to scroll to the bottom of the function menu with my mouse in Chrome. I had to use my touch screen to scroll past "Round".
(Edited)