https://community.qlik.com/t5/QlikView/Trim-a-String-in-Script/m-p/1532348#M438852 <P>load</P><P><SPAN>Replace(ITEM,&nbsp;' - Regular','') as Whatever</SPAN></P><P>&nbsp;</P> Fri, 18 Jan 2019 20:02:47 GMT m_woolf 2019-01-18T20:02:47Z https://community.qlik.com/t5/QlikView/Trim-a-String-in-Script/m-p/1532345#M438850 <P>I have a field called 'ITEM'</P><P>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.</P><P>For example,&nbsp;</P><P>ITEM</P><P>Salad</P><P>Salad - Regular</P><P>I want to trim the results where ITEM ends in ' - Regular' and just return 'Salad'</P><P>How can I do this in my load script?</P> Fri, 18 Jan 2019 19:34:42 GMT https://community.qlik.com/t5/QlikView/Trim-a-String-in-Script/m-p/1532345#M438850 EvanBarrick 2019-01-18T19:34:42Z https://community.qlik.com/t5/QlikView/Trim-a-String-in-Script/m-p/1532348#M438852 <P>load</P><P><SPAN>Replace(ITEM,&nbsp;' - Regular','') as Whatever</SPAN></P><P>&nbsp;</P> Fri, 18 Jan 2019 20:02:47 GMT https://community.qlik.com/t5/QlikView/Trim-a-String-in-Script/m-p/1532348#M438852 m_woolf 2019-01-18T20:02:47Z