Extracting values from specified HTML tags

Use case

You have a table containing HTML content. You need to extract values from specified HTML tags.

For example, "h3" headers from the 'Issue' column (the first match) and bold text (the "strong" tag) from the 'Comment' column (all matches).

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 *,
   FIND_VIEW(T1.'Issue', "h3") AS 'Issue HTML',
   FIND_VIEW(T1.'Comment', "strong", true) AS 'Comment HTML'
   FROM T1

   SQL

6. Save the macro and the page.