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?
Solved! Go to Solution.
You can use the Regular Expression tool and set it to Match.
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?
Regex is such a power tool to solve all my questions.