How to use "contains" function in router? I am getting error of expression failure

[ruchi_pandey]

Hi guys,

I am trying to use router with diff data scenarios, where I have to give conditions like:
1)
($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘DI_AVT_DH_PERSON_TYPE_ODS’,‘DI_AVT_DH_PERSON_CITIZENSHIP_ODS’,‘DI_AVT_DH_PERSON_LANGUAGE_ODS’))

If its true, goto Success flow or

2. ($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘DI_AVT_DH_PERSON_TYPE_STG’,‘DI_AVT_DH_PERSON_CITIZENSHIP_STG’,‘DI_AVT_DH_PERSON_LANGUAGE_STG’))

goto this flow.

But looks like this expression is not correct; hence I am getting error like:

Failure: Unexpected error occurred while evaluating expression: SC@7e0b949, Resolution: Please check your expression

Please suggest!

[anubhav_nautiya]

Great, issue was passing multiple arguments in contains fucntion.

[ruchi_pandey]

u r right!

[heidi_andrew]

I have seen some solutions here but nothing that is working for me. Here is my issue:

Looking all thru the expressions library for info on MATCH or CONTAINS I cannot find the right syntax to find this. How do you pull in multiple arguments?

$field002 in (“88017”,“88067”)

this works:
$field002 ==“88017”

how do i say IN (blah blah)
and NOT IN (blah blah)

I am used to sql expressions not Java.

[bojanvelevski]

Try the following expression:

$field002 matches "88017"|"88067"

[heidi_andrew]

bojanvelevski:

$field002 matches “88017”|“88067”

that worked but how do you say does not match? i tried ! and a few different ideas. kept getting errors