Table Transformer - Remove Text from a table cell

Craig Buchanan February 24, 2021

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
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 24, 2021

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*

Craig Buchanan February 24, 2021

Brilliant! Thank you so much

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events