# Adding regular expressions and SQL patterns to column analyses

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

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](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/using-regular-expressions-and-sql-patterns-in-column-analysis "You can add to any column analysis one or more regular expressions or SQL patterns against which you can match the content of the column to be analyzed.").

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](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/using-regular-expressions-and-sql-patterns-in-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](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/using-regular-expressions-and-sql-patterns-in-column-analysis).
* Generate a Talend Job to recuperate the valid/invalid data in the analyzed column. For more information, see [Recuperating matching and non-matching rows](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/recuperating-matching-and-non-matching-rows).