Search specific text in table transformer

Matias G Labrana

Hey all,

How can I do in table transformer to find between a line of text, a specific section to move into a new column?

the idea is every selection of text applied in the SQL query, will be located into one common column under the same name, in this case as the example says ''Selection''.

Thanks!

 

Stiltsoft support

Hi @Matias G Labrana ,

The Table Transformer macro is provided by the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

To search for special patterns in the strings and move these parts to separate columns, you may use the MATCH_REGEXP function. Please check this Community thread with a similar question: https://community.atlassian.com/t5/Confluence-questions/Table-Transformer-Sorting-out-multiple-values-from-a-column/qaq-p/2622470

Then, if required, you may concatenate these columns into one column.

If the question is not how to search for the specific patterns but to simply get the second part of the string divided by the "_" separator, then you may use the SPLIT function.

Please check the last answer in this Community thread where we show how to split cell contents in two parts by the "-" separator: https://community.atlassian.com/t5/Confluence-questions/Why-is-my-Gantt-chart-not-showing-the-JIRA-ticket-names/qaq-p/1359981