Skip to Content
Author's profile photo Shaheen Makandar

Using match_regex function to replace “LIKE” function in Information Steward Rules

I came across a requirement in Information Steward, to create a Rule that looks for the word “Competitor” in the column string, The name of the columns was NOTES (lets just say).

This word”Competitor” can be at any location in the string and can be in case. If this word exists, then the rule should pass the value else fails it.

The equivalent SQL Query for this would be simple:



But to do the same in the Rule, we do not have the LIKE function.

Instead, we had to use the following formula (using match_regex function) to perform the same task.



match_regex($parameter0, ‘.*COMPETITOR.*’, ‘CASE_INSENSITIVE’);


This will do the trick.


Shaheen Makandar

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.