Searching in the string with a regular expression

Use case

You need to search for a specific pattern in the string and display the matching parts in a new column.

For example, among the "LettersNumbers" (A10, B12, UT7) components you need to find all the "Numbers/Numbers" (08/15, 10/11) components and show them in a separate column.

Solution

1. Switch the page to the edit mode.

2. Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.

3. Select the macro and click Edit.

4. In the Presets tab select Custom transformation and click Next.

5. Enter the following SQL query:

   SELECT *,
   MATCH_REGEXP(T1.'Component', "\d+/\d+", "g")
   AS 'Component with /'
   FROM T*

   SQL

   Here the "\d+" regular expression stands for any number of digits. To learn more about regular expressions, you may check this guide.

6. Save the macro and the page.