Creating a regular expression to match the cities - Cloud

Talend Cloud Data Preparation Quick Examples

English (United States)
Talend Cloud
Talend Data Preparation
Data Quality and Preparation > Cleansing data

You will create a regular expression to match all the cities you are interested in, in other words the five biggest cities in France: Paris, Lyon, Marseille, Toulouse, and Bordeaux.


  1. Click the header of the city column to select its content.
  2. In the functions panel, on the right side of the screen, type Match pattern and click the result to open the options for the associated function.
  3. In the Pattern field, select Other.
  4. From the Manual pattern drop-down list, select RegEx.
  5. In the Manual pattern field, enter the following regular expression:

    This expression will match all the sales that occurred in these five cities.

  6. Click Submit.


A new column is created, where rows that match the regular expression are marked as true, while those who do not are marked as false.