IS Rules with text substrings searches

[Former Member]

We are using IS 4.1 and are trying to implement rules that scan text to find certain words. If those words exist, then we can mark the data as failing.

There are no contains or like functions in the string rules within the advanced editor. Also regular expression substrings are not supported in 4.1.

How have others solved this?

[former_member298829 · Accepted solution]

Hi Thomas,

In IS 4.1 you can use any of the following:

• LIKE in an expression
  e.g. IF (upper($NAME) LIKE '%INTERNAL%') ....
• match_regex()
• match_pattern() - as suggested above

Regards

Nigel

[Former Member · Accepted solution]

Thanks for your responses. I implemented the like function and it is doing what I'm expecting. This is how I constructed it:

BEGIN

    # define processing steps

    IF ((Upper($Color) like '%BLUE%') and ($ColorCode != 'BL'))

    BEGIN

        RETURN FALSE;

    END

    ELSE

        RETURN TRUE;

END

[former_member655569]

Try like below.

((NOT match_pattern(upper($CustName), '*INTERNAL*')) OR  (NOT match_pattern(upper($CustName), '*JANITORIAL SUPPLIES*')) OR (NOT match_pattern(upper($CustName), '*EMPLOYEE PURCHASES*'))

let me know if it works.

[mageshwaran_subramanian]

Thomas,

I guess substr is available in 4.1 .Its also documented here.Refer Page 43

http://help.sap.com/businessobject/product_guides/sboIS41/en/sbo411_is_user_en.pdf

This function is supported in 4.0 as well.