Check if text contains certain words

[guyvermeiren]

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]

Hi,

     Check with this

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

Celambarasan