String character function for data quality testing

[Wangwn]

Doing a data quality test, a lot of rules such as minimum 2 alpha/numeric characters or 3 or more consecutive letters are not allowed. Any String functions available for those testings?

[roadhouse · Accepted solution]

You can use the Regular Expression tool and set it to Match.

[Wangwn]

Thank you! I am able to use Regex_match to screen if a string has the minimum 2 alpha or numeric characters, how about idenfity  consective letters or count the unique characters that a string has, also use Regex_match?

[Wangwn]

Regex is such a power tool to solve all my questions.