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
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'