sql-serverregexdata-quality-services

DQS - Regex to detect invalid country names

I'm creating a domain rule to avoid values in my country domain that won't correspond to country long name/two-letter code/Three-letter code/Numeric code and native title.

Could you please help me create a rule to capture native characters like hiraganas and Arabic letters?

This is how my domain values look like

enter image description here

I'm trying to capture values like

This is my progress so far

enter image description here

Also, I'm wondering what is the dialect used by DQS for regex.

Solution

  • Maybe you can use Unicode Categories on the regular expressions. Check how to do this here:

    https://www.regular-expressions.info/unicode.html