Compare two text withouth case sensitive

Andrea
edited October 15, 2019 in Questions
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

Comments

  • Bill McCullough
    Bill McCullough πŸ’ŽπŸ’Ž
    edited October 4, 2017
    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
  • Andrea
    edited January 9, 2018
    Thank you Bill!!

  • Skuidward Tentacles (Raymond)
    edited October 15, 2019
    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".
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!