Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called 'ITEM'
There are certain 'ITEMS' that are in the data that I would like to trim the end of the string of characters in certain rows of data.
For example,
ITEM
Salad
Salad - Regular
I want to trim the results where ITEM ends in ' - Regular' and just return 'Salad'
How can I do this in my load script?
load
Replace(ITEM, ' - Regular','') as Whatever