Confluence / Jira Table Transformator Macro - SPLIT / SUBSTRUNG - lost format

[Schmidl82]

Hi,

I use the table transformer macro in confluence to display Jira tickets.

The jira tickets have bilingual content in the decription field.

I try to seperate via SQL query by the SPLIT or SUBSTRING function with a separation character (#)

Example: 

SUBSTRING(T1.'description',1, INSTR(T1.'description', "#")-1) AS 'description'

This gives me the String from the start to the #.

Here's my problem: all the format is lost, no line breaks, no hyperlinks, no bold/underline fonts. In fact, I get the pure STRING.

Is there a solution to keep the format?

Thanks in advance!

Christian

[Stiltsoft support]

Hi @Schmidl82 ,

Seems that you are talking about our Table Filter, Charts & Spreadsheets for Confluence app.

The described behavior seems to be an expected one: the cells' data is treated like a string, as a result you get a modified string. The format is not preserved as it is not a characteristic of a string.

The workaround may be to split your strings as a first step and then use the FORMATWIKI function or CSS styles to format the outcome.

If you are stuck and need to share more details to guide you through the case, please contact our support portal directly. The portal is confidential.