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 How to add 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 How to edit 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 How to view the data analyzed against patterns.