nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hyperlink retrieved incorrectly while using Formatwiki

emagnun

Hi,

Below is my table that prints the data as "17 issues" as a link. I'm trying to get this printed as only numbers. i.e. just "17" while maintaining the same link address.

1) I tried REPLACE function and it printed "17" but the links were gone. Is there a workaround here?

2) Then I was trying to use the FORMATWIKI function to retrieve the link info of "High" column, but the link info was incorrectly retrieved. Below is my code for table transformer.

SELECT T1.'High'->match("^[0-9]+") AS 'High', FORMATWIKI(T1.'High'->tfView->match("href=([^ >]*)")->1->slice(1, -1)) AS 'Link' FROM T1

Accepted answers

Stiltsoft support

Hi @emagnun ,

If you are talking about our Table Filter, Charts & Spreadsheets for Confluence app and its Table Transformer macro, you may visit its list of supported functions - the REPLACE_VIEW function that preserves original formatting may suit you:

SELECT *,
REPLACE_VIEW(T1.'High', " issues", "") AS 'Number without issues'
FROM T*

All comments

Stiltsoft support

Hi @emagnun ,

SELECT *,
REPLACE_VIEW(T1.'High', " issues", "") AS 'Number without issues'
FROM T*

emagnun

original code worked but i have a follow up question

emagnun

Awesome. This is exactly what I was looking for.

It is possible to do an OR for this REPLACE VIEW? Basically, if text contains " issues" or " issue", i want to to replace with "".

Stiltsoft support

I don't think so, but you may use two SELECTs:

SELECT *,
REPLACE_VIEW('High', "s", "") AS 'High'
FROM
(SELECT *, REPLACE_VIEW(T1.'High', " issue", "") AS 'High'
FROM T1)

Please note that in the internal SELECT we can refer to column names with and without the T1 prefix (here we work with the original table).

But in the external SELECT we refer to the already modified table, so it is 'High' and not T1.'High'.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table

table-filter

table-filter-and-charts

table-transformer

table-filter-charts-spreadsheets