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
Community Members
Community Events
Community Groups

Table Transformer - Remove Text from a table cell


I am looking for help to remove text from within a cell to allow for a function to be performed

As an example


trying to convert to be:

Table 2.PNG

This will allow multiplication by set values to return the sale price in a separate column

1 answer

1 accepted

2 votes
Answer accepted

Hi @Craig Buchanan ,

You may try the following SQL query to split your text cell by the space symbol between the quantity number and the item name:

SELECT T1.'Produce'->split(" ")->0 AS 'Quantity',
T1.'Produce'->split(" ")->1 AS 'Produce'

Brilliant! Thank you so much

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events