Skip to main content
Nintex Community Menu Bar
Question

Compare two text withouth case sensitive

  • July 11, 2024
  • 3 replies
  • 12 views

Forum|alt.badge.img+3

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

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+10

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


Forum|alt.badge.img+3

Thank you Bill!!


Forum|alt.badge.img+17

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”.