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,364,566
Community Members
 
Community Events
168
Community Groups

Table Transformer - Remove Text from a table cell

Hi,

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

As an example

Table.PNG

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'
FROM T*

Brilliant! Thank you so much

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events