Search text part in if statement

[pauldamen]

    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

[#2 · Accepted solution]

Hi Paul,

You can use the wildmatch function like this:

if(WildMatch(cm_parentid, '*control*'), 'Control', if(WildMatch(cm_parentid, '*performancemanagement*'), 'Performance Management'))

Hope it helps.