If(word exists in discription dimension) help please

building reports webintelligence
1

Hiya,

I have a description field like a verbatim field and im wondering how to group instances if certain words are in the description.
for e.g.

if a description contains the word Insurance i want to tag it as Insurance related and so on.

any ideas as i cant seem to find a contains function in webi?

cheers :slight_smile:

Ben Elford (BOB member since 2010-04-27)

2

Hi,

Check the Match() function.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Im looking to try and icorporate that into an if statment, some thing like below

=If([Case Details] Match([Case Details];“Insurance”);“Insurance Realated”;“Unkown”)

which would group all the case details containing insurance into one group called insurance if that makes sense.

Ben Elford (BOB member since 2010-04-27)

4

Hi,

The formula should look like this:

=If( Match([Case Details];"*Insurance*");"Insurance Realated";"Unknown")

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Thats spot on!!

thanks for you help on this one :smiley:

Ben Elford (BOB member since 2010-04-27)

6

You’re welcome 8)

One additional note:
If the word Insurance can be written with the mix of small and caiptal letters then it’s better to convert the string to upper case before using the Match() function. Something like this:

=If( Match(Upper([Case Details]);"*INSURANCE*");"Insurance Related";"Unknown")

Marek Chladny :slovakia: (BOB member since 2003-11-27)