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; } } }

Retrieve text (only) from table cell

Jorge Sabino

Hi!

I have a table from which cells I'd like to retrieve just the text - no format, no column name, no table.... - nothing but the text. Is this feasible?

If it is possible, how can I do that?

I've been trying Table Filter and Table Transformer with Table Excerpt Include, but I've not been able to get rid of the table frame...

thanks in advanced!

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Jorge Sabino ,

Please, clarify the case - do you need to retrieve data within a specific cell?

Then it won't be a problem: just put the Table Excerpt macro inside the cell and wrap its contents. Then reuse the Excerpt via the Table Excerpt Include macro (don't forget to tick the "Show a copy of the source table" option if you do it on the same page). The contents of the cell will be shown as plain text.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Jorge Sabino ,

Please, clarify the case - do you need to retrieve data within a specific cell?

Katerina Kovriga {Stiltsoft}

Or maybe the following case will suit you: for example, I reuse a table via the Table Excerpt/Table Excerpt Include macros but want to show only one specific cell as plain text.

So you may wrap this Table Excerpt Include (or a manually created table for my example) in the Table Transformer macro and find the required cell:

Fri 6-1.png

SELECT 'Date'
FROM T*
WHERE 'Phase' LIKE SELECT 'Date'
FROM T*
WHERE 'Phase' LIKE "%Development%" Fri 6-2.png

For example, here I want to show the date that corresponds the "%Development%" phase.

The result is a one-cell table with a header.

To remove the header and borders, go to the "Options" tab:

Fri 6-3.png

Now you get plain text as a result:

Fri 6-4.png

Note that if you don't see the "Show result as plain text" option, it means that you need to update the app - it's a new feature. The current version is 9.2.1 - please check and update if necessary.

Hope this helps.

Jorge Sabino

Hi Katerina,

Thank you for your answer.

Actually, I cannot edit the table I'm trying to fetch from - that is why I was being strict about getting only the text from the cell - so the first option is not in my grasp.

The last use case is exactly what I'm looking for. Let me just try that and I'll report back.

Thanks again for the alternatives on the answers.

Regards,
Jorge

Jorge Sabino

ah.... it seams like I have an "older" version:
Screenshot from 2022-09-14 20-52-02.png

Could I include the removal of the header and borders on the query itself?

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

filter

table

table-filter

format

excerpt

table-excerpt

table-filter-and-charts

table-transformer