1 Reply Latest reply on Sep 27, 2016 4:55 PM by diego.medrano

    How To highlight a particular word in a string

    Arpan Dey

      Hi All,

       

      Here is an easy way to highlight particular word from a long string

       

      Create a formula and name it color the Word!!

       

      IF

          CONTAINS([Description],'Rude')      // to find the text

      Then

          'Rude'                                                // to display the text or you could define it as a color as well example: 'orange' 

      ELSEIF

          CONTAINS([Description],'Disagreement (not installed)')

      Then

          'Disagreement (not installed)'

      ELSEIF         

          CONTAINS([Description],'Rubbish ')

      Then

          'Rubbish '

      ELSEIF

          CONTAINS([Description],'behaviour')

      THEN

          'Behaviour'

      ELSEIF

      CONTAINS([Description],' did not wait long enough')

      THEN

          ' did not wait long enough'

      ELSEIF

      CONTAINS([Description],'dust')

      THEN

          'Dust'

      ELSEIF

      CONTAINS([Description],'mess')

      THEN

          'mess'

      END

       

      Then put the calculation in text mark card and on color as well to differentiate it


      Hope this helps!!

       

      OR is there any other way you would do it??

       

      Thanks