Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,242
Community Members
 
Community Events
168
Community Groups

Retrieve text (only) from table cell

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!

1 answer

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.

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.

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

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?

I'm afraid this is not possible within the SQL query: at this stage the macro "sees" the source table as a mini database, so its headers are considered as crucial points and can't be removed.

The option to show the result as plain text corrects the macro output if the result table is a one-cell table automatically. This option was introduced both to the Table Transformer and Pivot Table macros, so you need to update the app.

Hi Katerina,

Thanks once again for your attention.

I'll have to live with my pain until the version gets updated then...

Regards,
Jorge

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events