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.
- Click the header of the city column to select its content.
- 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.
- In the Pattern field, select Other.
- From the Manual pattern drop-down list, select RegEx.
In the Manual pattern
field, enter the following regular expression:
This expression will match all the sales that occurred in these five cities.
- Click Submit.
true, while those who do not are marked as