Pattern Matching in DQS Domain Rules

Pattern Matching in DQS Domain Rules

Rate This
  • Comments 4

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

Leave a Comment
  • Please add 8 and 8 and type the answer here:
  • Post
  • 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

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

  • 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.

  • 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

Page 1 of 1 (4 items)