Using regular expressions and filters to create "or" conditions on customer data - Cloud

Talend Cloud Data Preparation Quick Examples

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
The car_dealership.xlsx dataset contains information about the customers of a worldwide car dealership company, with relevant categories such as their names, driving experience, car manufacturer, model and year, or the city where the car was bought.

This scenario will illustrate how to use regular expressions to select specific values and create "or" conditions to match data that cannot be selected with usual filters. You will be able to perform cleansing operations on the rows that correspond to your criteria, or simply export them.

Retrieve the car_dealership.xlsx file from the Downloads tab of the documentation page.