topic advanced cleaning string in QlikView https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287582#M106969 <HTML><HEAD></HEAD><BODY><P>i have a data like this</P><P></P><P>abc brand</P><P>cde</P><P>fgh</P><P>ijk Brand</P><P></P><P></P><P>i need a formula where i can omit the word "Brand" if it is exist in data and need result like this</P><P></P><P>abc</P><P>cde</P><P>fgh</P><P>ijk</P><P></P><P></P><P>any answer?</P><P></P><P></P><P>thanks</P><P>Lavi</P></BODY></HTML> Tue, 01 Nov 2011 09:27:14 GMT 2011-11-01T09:27:14Z advanced cleaning string https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287582#M106969 <HTML><HEAD></HEAD><BODY><P>i have a data like this</P><P></P><P>abc brand</P><P>cde</P><P>fgh</P><P>ijk Brand</P><P></P><P></P><P>i need a formula where i can omit the word "Brand" if it is exist in data and need result like this</P><P></P><P>abc</P><P>cde</P><P>fgh</P><P>ijk</P><P></P><P></P><P>any answer?</P><P></P><P></P><P>thanks</P><P>Lavi</P></BODY></HTML> Tue, 01 Nov 2011 09:27:14 GMT https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287582#M106969 2011-11-01T09:27:14Z advanced cleaning string https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287583#M106970 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>&nbsp; </P><P>Use this code</P><P>=Trim(replace(replace(YourColumn,'Brand',''),'brand',''))</P><P>&nbsp; </P><P>Rgds</P><P>Anand</P></BODY></HTML> Tue, 01 Nov 2011 09:41:06 GMT https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287583#M106970 its_anandrjs 2011-11-01T09:41:06Z Re: advanced cleaning string https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287584#M106971 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached sample file</P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Tue, 01 Nov 2011 09:43:14 GMT https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287584#M106971 its_anandrjs 2011-11-01T09:43:14Z advanced cleaning string https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287585#M106972 <HTML><HEAD></HEAD><BODY><P>thanks Anand</P></BODY></HTML> Tue, 01 Nov 2011 09:46:46 GMT https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287585#M106972 2011-11-01T09:46:46Z advanced cleaning string https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287586#M106973 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks! You are welcome.</P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Tue, 01 Nov 2011 09:48:28 GMT https://community.qlik.com/t5/QlikView/advanced-cleaning-string/m-p/287586#M106973 its_anandrjs 2011-11-01T09:48:28Z