Reltio Connect

 View Only
  • 1.  Filter required in Match Rule (Ignore string consist of all same chars)

    This message was posted by a user wishing to remain anonymous
    Posted 12 days ago
    This message was posted by a user wishing to remain anonymous

    Hi All,

    We need to create a match rule ensuring that the Id attribute is not null, not composed solely of whitespace, and not a string consisting of repeated identical characters (e.g., numeric values such as 0000, 00, or 000000000, alphabetic values such as XXX or xxxxx, or mixed-case repetitions like XXxXXX). Tried regex ^(.)(?!\\1+$).*$ but it does not produce the expected results, as it only compares the first character rather than validating the entire string. The expected behavior is as follows:

    1. 768976547 and 768976547 → Match: True
    2. 768976547 and 768976546 → Match: False
    3. 444444 and 444444 → Match: False
    4. 4444441 and 4444441 → Match: True.


    -------------------------------------------


  • 2.  RE: Filter required in Match Rule (Ignore string consist of all same chars)

    Reltio Employee
    Posted 12 days ago

    Try regex (?i)^([a-z0-9])\1+$=> in the RegexpReplaceCleanser, and compare the attribute using exact operator 



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Solution Architect
    Reltio
    Bangalore
    ------------------------------