Open Studio for Data Quality
You can use regular expressions and SQL patterns in column analyses in order to check all existing data in the analyzed columns against these expressions and patterns. For more information, see Adding a regular expression or an SQL pattern to a column analysis.
You can also edit the regular expression or SQL pattern parameters after attaching it to a column analysis. For more information, see Editing a pattern in the column analysis.
After the execution of the column analysis that uses a specific expression or pattern, you can access a list of all valid/invalid data in the analyzed column. For more information, see Viewing the data analyzed against patterns