Table Transformer - Remove Text from a table cell

[Craig Buchanan]

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_ · Accepted solution]

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]

Brilliant! Thank you so much