3 Replies Latest reply on Apr 9, 2018 1:32 PM by Deepak Rai

    Finding Multiple words from String

    SambiReddy Chanimella

      Hi All,


      I have a scenario where to find 'AP disassociation' related incidents and pasted below couple of examples how my description was given and both are 'AP Disassociated'  related incidents but entered differently


      From second Text i got all the related Incidents using  IF CONTAINS([Short Description],'AP Disassociated') THEN 'AP Disassociation'

      but coming to first description there is some content between AP and disassociation which is in single comma.


      Is there any way to create calc to get 'AP Disassociated' incidents by excluding the context which is in between commas.


      Appreciate if some can help quickly !!