use Pattern or an other rule

Question

I have some records; by example: 6712098, 8912099, 3312100, 3212111, 5414889

The third and fourth number in de record must be 1 and 2, if not the value is wrong.

I want to use the Pattern-rules but I think it's not possible. Or...?

Is there an other solution in DQS so I can make a rule for this situation?

Answer 1

DQS Pattern matching isn't possible to use here because you are saying the 3rd and 4th numbers must be specific numbers--  in Pattern matching in DQS, any number will match any number.  But you could define this rule with a regular expression and that is possible in DQS Domain Rules with the Value Matches Regular Expression rule type.  Here is some info on DQS Pattern matching http://blogs.msdn.com/b/dqs/archive/2012/10/08/pattern-matching-in-dqs-domain-rules.aspx

Answer 2

No, you cannot do such validation for numeric domains (Decimal and Integer) in DQS because pattern matching and regex domain rules are only available for a domain of String data type.

For the numeric domains, we only have the following domain rule conditions available:

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---