Delphix Products

 View Only
  • 1.  ASDD Profiling Clarification - "Partial Match"

    Posted 26 days ago

    Hello,

    I'm in the process of converting our old profile sets to the new classifier format and have a question regarding Partial Matching.

    With partial matching, does this mean the regex can match part of a value and be flagged by the profiler or that only one or some capturing groups need to match?

    I've created regex that doesn't include start and end qualifiers (i.e. "^(pattern)$" ) but isn't capturing sensitive data embedded in other text - any pointers would be appreciated. 

    Cheers,



    ------------------------------
    Samantha Williams
    Masking Engineer
    ANZ Bank New Zealand Limited
    ------------------------------


  • 2.  RE: ASDD Profiling Clarification - "Partial Match"

    Posted 26 days ago

    Hi Samantha,

    You can use regex101.com to test and validate your regular expression. Just make sure to select Java 8 as the regex (on the left side).

    Regarding your question, it seems you're looking to match any word between brackets.

    Here's an expression you can use for that: 
    "^\(.+\)$"

    Best,






    ------------------------------
    Mouhssine Saidi
    Technical Services
    Delphix
    ------------------------------



  • 3.  RE: ASDD Profiling Clarification - "Partial Match"

    Posted 26 days ago

    Partial match means that it can match a "word" within the entire string. String is split into "words" by space or equiv separators (\\s+).

    If you match for TEST and value is NEW TEST it will not match > but with partial match it does match.

    Regex101 is a good option > use Java 8 on left and GMI on center top (add I as case insensitive)



    ------------------------------
    Tino Pironti
    Masking SME
    Technical Manager
    Delphix
    ------------------------------