Use caseLink to Use case

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

SolutionLink to 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
    SQL
  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.