Use Case

You need to find any values of the 'Customer Name' column that have "é" in any position.

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 *
FROM T1
WHERE 'Customer Name' LIKE "%é%"
    SQL
  6. Save the macro and the page.

LIKE "a%" - Finds any values that start with "a"
LIKE "%a" - Finds any values that end with "a"
LIKE "_r%" - Finds any values that have "r" in the second position
LIKE "a_%" - Finds any values that start with "a" and are at least 2 characters in length
LIKE "a__%" - Finds any values that start with "a" and are at least 3 characters in length
 LIKE "B%s" - Finds any values that start with "B" and ends with "s"

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