topic Re: filtering in QlikView https://community.qlik.com/t5/QlikView/filtering/m-p/394884#M147278 <HTML><HEAD></HEAD><BODY><P>purgechar(ItemName,';') will remove the semicolon. Is that all you need or do you need only the last part of ItemName after the last hypen? purgechar(trim(Subfield(ItemName,'-',-1)),';')</P></BODY></HTML> Fri, 04 Jan 2013 20:15:32 GMT Gysbert_Wassenaar 2013-01-04T20:15:32Z filtering https://community.qlik.com/t5/QlikView/filtering/m-p/394883#M147277 <HTML><HEAD></HEAD><BODY><P>Hi Friends ,</P><P></P><P>I have data like below table , in that ItemName field having the text with ; (Semicolon) , i need to filter , i need that value without Semicolon</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">ItemNum<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">ItemName<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Qty<BR /></TH></TR><TR><TD>11011</TD><TD>05.11.12 - 05.11.12 - 6404 - abcdefg&nbsp; - Ondfer&amp;aelig;re timer</TD><TD>23</TD></TR><TR><TD>11022</TD><TD>04.11.12 - 04.11.12 - 7004 - abcdefg&nbsp; - Ondfer&amp;aelig;re timer</TD><TD>30</TD></TR><TR><TD>11033</TD><TD>05.11.12 - 05.11.12 - 9004 - Statiost vakhold extra&nbsp;&nbsp; - Timer na</TD><TD>230</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks in Advance</P><P>Janardhan</P></BODY></HTML> Fri, 04 Jan 2013 19:36:21 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/394883#M147277 janardhan 2013-01-04T19:36:21Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/394884#M147278 <HTML><HEAD></HEAD><BODY><P>purgechar(ItemName,';') will remove the semicolon. Is that all you need or do you need only the last part of ItemName after the last hypen? purgechar(trim(Subfield(ItemName,'-',-1)),';')</P></BODY></HTML> Fri, 04 Jan 2013 20:15:32 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/394884#M147278 Gysbert_Wassenaar 2013-01-04T20:15:32Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/394885#M147279 <HTML><HEAD></HEAD><BODY><P>Hi Wassenaar ,</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">purgechar(ItemName,';') this function works fine.</SPAN></P><P></P><P>Thanks a lot </P></BODY></HTML> Fri, 04 Jan 2013 20:32:57 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/394885#M147279 janardhan 2013-01-04T20:32:57Z