Table Transformer - Remove Text from a table cell

Craig Buchanan_mljjec

Hi,

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:

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

Katerina Kovriga {Stiltsoft}

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*