# Using regular expressions and SQL patterns in a column analysis

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
* MDM Platform
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

You can use regular expressions or SQL patterns in column analyses. These expressions and patterns will help you define the content, structure, and quality of the data included in the analyzed columns.

For more information on regular expressions and SQL patterns, see [Patterns and indicators](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/profiling-and-data-quality) and [Steps to analyze database tables](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/tables-analyses "You can examine the data available in single tables of a database and collect information and statistics about this data.").

### In this section

* [Adding a regular expression or an SQL pattern to a column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/adding-regular-expression-or-sql-pattern-to-column-analysis)
* [Editing a pattern in the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/editing-pattern-in-column-analysis)
* [Viewing the data analyzed against patterns](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/viewing-data-analyzed-against-patterns)
* [Recuperating valid and /or invalid rows](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/recuperating-valid-and-or-invalid-rows)