Rules Engine partial matches


#1

Hello,
I have a list of terms in a field called Lines of Business containing records like:
ACCIDENTAL
DENTAL
DENTAL,LIFE
HOSPITAL,ACCIDENTAL

I’m trying to use the rules engine to return partial matches where the field contains the substring. I’ve tried a few different variations use LIKE and MATCHES and even simple =

For instance
$Lines of Business$ LIKE “?DENTAL?”=> “LikeDental”
$Lines of Business$ LIKE “DENTAL”=> “LikeDental”

It should return “LikeDental” for all the example records, above. However I can only get the exact match to return a result. I seem to be missing something obvious. Any helpful ideas?


#2

Hi,

the ? sign means 1 character. So as There is no matches in your records (one that has 1 character before and 1 character after “DENTAL”) you get nothing in that case.
You can use * sign which means 0 or more characters to get all the values which contain “DENTAL”.

Best,
Armin


#3

Thanks Armin. That did the trick. I thought I had tried that already, but might have not been * with the LIKE operator.


#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.