Discussion Board for collaboration related to QlikView App Development.
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.
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?
Go to Solution.
Replace(ITEM, ' - Regular','') as Whatever