1 Reply Latest reply: Dec 28, 2012 4:47 AM by Jean-Pierre Bakhache RSS

    Search text part in if statement

    Paul Damen

          Hi,

       

      I have a whole list of website links which I want to aggregate in an other listbox. For example if have all kinds of links that contain the word control, using a if statement I want to put this in a listbox (I have 8 groups I want to put the words in), so my if statement looks like this:

       

      if(cm_parentid = '*control*', 'Control', if(cm_parentid = '*performancemanagement*', 'Performance Management', etc. etc.

       

      The problem is that it doesn't understand the * as a fuzzy search. How can I make this listbox using parts of the word?

       

      Thanks!

       

      Paul