You will create a regular expression to match all the dates you are interested in, namely 1950, 1960, 1970, 1980, 1990, 2000 and 2010.
- Click the header of the car_year column to select its content.
- In the functions panel, on the right side of the screen, type Matches 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
This expression will match all the rows with sales involving cars from the year 1950, 1960, 1970 and so on.
- 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