Text formatting

Use case

You need to format text in some of your columns.

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  FORMATWIKI(T1.'Plain text') as 'Plain Text', 
   FORMATWIKI("_",T1.'Italics', "_") as 'Italics',
   FORMATWIKI("*",T1.'Bold', "*") as 'Bold',
   FORMATWIKI("*","_",T1.'Italics Bold',"_", "*") as 'Italics Bold',
   FORMATWIKI("~",T1.'Subscript', "~") as 'Subscript',
   FORMATWIKI("^", T1.'Superscript', "^") as 'Superscript',
   FORMATWIKI("-",T1.'Strikethrough', "-") as 'Strikethrough',
   FORMATWIKI("{{",T1.'Monospace',"}}") as 'Monospace',
   FORMATWIKI("{noformat}",T1.'No format',"{noformat}") as 'No format',
   FORMATWIKI("+",T1.'Inserted',"+") as 'Inserted',
   FORMATWIKI( "\nbq. Example") as 'Block quotation'  
   FROM T1

   SQL

6. Click Next. 

7. Define the table settings and view options if needed. 

8. Save the macro and the page.