Use case

You need to find the first four values in the range from 0 to 8 in an 'ID' column.

Solution

  1. Switch the page to the edit mode.
  2. Insert the Table Transformer macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. Switch to the SQL query tab.

  5. Enter the following SQL query:

    SELECT
'ID'->match("^[0-8]{4}") AS 'Year', 'Brand'
FROM T1
  6. Save the macro and the page.

The [0-9] expression is used to find any character between the brackets.
Use the [^0-9] expression to find any character that is NOT a digit.

[aeiou] matches any one of the charachers within the the square bracket.
[a-zA-Z]  matches any uppercase or lowercase letters.
^ matches the beginning of the input string,
{4} means the number of characters to display

Here you can find more info about JavaScript regular expressions.

You can use FORMATWIKI function for the purposes of cell formatting.