Check if text contains certain words

guyvermeiren — Fri, 27 Apr 2012 13:34:34 GMT

Hello,

If have a calculated dimesion where i want to check on the content of the fields.

Example:

I have a number of "Trainings":

"Advanced training electronics"

"Advanced training mechanics"

"Basic training electronics"

"Basic training mechanics"

"Specialists training"

Now I want to create a calculated dimension where I get Null() if the trainingname contains "Advanced training"

Thanks for your help on the formula.

Kind regards,

Guy

CELAMBARASAN — Fri, 27 Apr 2012 13:57:32 GMT

Hi,

Check with this

If(not WildMatch(Trainings,'*Advanced training*'), Trainings)

Celambarasan

topic Check if text contains certain words in Water Cooler