Pattern Matching in DQS Domain Rules


This post provides you information on how to use the pattern matching rules in DQS while creating domain rules. These are the four pattern matching rules in DQS: 

For a pattern matching rule:

  • Any  letter (A…Z)  can be used as a pattern for any letter; case insensitive
  • Any digit (0…9) can be used as a pattern for any digit
  • Any special character, except a letter or a digit, can be used as a pattern for itself
  • Brackets, [], define optional matching

Example 1:

Consider the following pattern matching rule to represent Employee Code:

This rule implies that the Employee Code will contain three parts: any three letters followed by a colon (:), which is again followed by any four digits.

In this case, following are some valid values as per the rule:

 

And, following are some invalid values as per the rule:

Example 2:

Consider the following pattern matching rule for an Employee Code that shows optional matching:

This rule implies that the Employee Code will contain three parts: any three letters followed by a hyphen (-), which is again followed by any four or five digits.

In this case, following are some valid values as per the rule:

And the following are some invalid values as per the rule:

Thanks,         
DQS Team

Comments (4)

  1. Srinivas says:

    I want to Check

    1.  Column A value with Column B

    2.  Content of Column C,D,E  if is part of Column F. I.e,m  

        Column C: 'My"

        Column D: "Name"

        Column E: "IS Srinivas"

        Column F: :My Name is Srinivas"

    Then its a correct row. Else its a wrong row. Pls advise how I can do this

  2. Anonymous says:

    Srinivas, I think it cannot be done using DQS as of now.

  3. farhan says:

    I want to Check

    1.  Column A value with B

    2.  Content of Column C,D,E  if is part of Column F. I.e,m  

       Column C: 'Me"

       Column D: "Name"

       Column E: "Is Farhan"

       Column F: :My name is Farhan"

    Then its a correct row. Else its a wrong row. Please advise how I can do this.

  4. Raj says:

    My requirement is,

    to match data across different type.

    For Example i want to match the team A record woth Team b record. I dont want to match the Team A record with Team A an Team B with Team B. Please advice me on this

Skip to main content