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.
Procedure
-
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:
^Paris$|^Marseille$|^Lyon$|^Toulouse$|^Bordeaux$
This expression will match all the sales that occurred in these five cities.
-
Click Submit.
Results
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.