# Cleansing strings

### In this section

* [Extracting email address parts](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/extracting-email-address-parts)
* [Extracting part of a text](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/extracting-part-of-text)
* [Extracting parts of a full name](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/extracting-parts-of-full-name)
* [Extracting parts of a field based on semantic types](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/extracting-parts-of-field-based-on-semantic-types)
* [Replacing the content of cells with another value](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/replacing-content-of-cells-with-another-value)
* [Filling empty cells with text](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/filling-empty-cells-with-text)
* [Concatenating columns](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/concatenating-columns)
* [Clearing cells corresponding to a pattern](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/clearing-cells-corresponding-to-pattern)
* [Deleting rows containing a specific value](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/deleting-rows-containing-specific-value)
* [Standardizing values using dictionaries](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/standardizing-values-using-dictionaries)