Forum Discussion

ruchi_pandey's avatar
ruchi_pandey
New Contributor II
7 years ago
Solved

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

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_PERS...
  • ruchi_pandey's avatar
    ruchi_pandey
    7 years ago

    I solved this issue actually…
    I gave this exp and it worked.

    ($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘PERSON_TYPE_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_CITIZENSHIP_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_LANGUAGE_ODS’) )

    THanks for your quick response though… 🙂

heidi_andrew's avatar
heidi_andrew
Contributor
4 years ago

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

bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Wrap the whole expression in parenthesis and a NOT operator:

!($field002 matches "88017"|"88067")