Trim a String in Script

[EvanBarrick]

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?

[m_woolf · Accepted solution]

load

Replace(ITEM, ' - Regular','') as Whatever