Changing a link text and preserving it clickable

Use case

You need to change a text for links and preserve it clickable.

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 T1.'Company',
   FORMATWIKI( "[Click here|" +
    T1.'Link'->tfView->match("href=([^ >]*)")->1->slice(1, -1) 
    + "]"
    ) AS 'Link'
   FROM T*

   Copy

   SQL

6. Save the macro and the page.