topic Re: Trim in QlikView https://community.qlik.com/t5/QlikView/Trim/m-p/346251#M702580 <HTML><HEAD></HEAD><BODY><P>The field name is MEM_ID. So I want to remove { }&nbsp; while loading from around 50,000 records and not just for one ID.</P><P></P><P>Thanks,</P><P>H</P></BODY></HTML> Wed, 11 Jul 2012 17:04:01 GMT hkg_qlik 2012-07-11T17:04:01Z Trim https://community.qlik.com/t5/QlikView/Trim/m-p/346249#M702578 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an ID in a QVD file which looks like {9038585065}.</P><P></P><P>I want to remove the { } from all the ID's I have in the QVD File while loading.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Wed, 11 Jul 2012 16:48:59 GMT https://community.qlik.com/t5/QlikView/Trim/m-p/346249#M702578 hkg_qlik 2012-07-11T16:48:59Z Re: Trim https://community.qlik.com/t5/QlikView/Trim/m-p/346250#M702579 <HTML><HEAD></HEAD><BODY><P>You may also use</P><P></P><P>PurgrChar(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">'{9038585065}</SPAN>','{}')</P></BODY></HTML> Wed, 11 Jul 2012 16:58:15 GMT https://community.qlik.com/t5/QlikView/Trim/m-p/346250#M702579 nagaiank 2012-07-11T16:58:15Z Re: Trim https://community.qlik.com/t5/QlikView/Trim/m-p/346251#M702580 <HTML><HEAD></HEAD><BODY><P>The field name is MEM_ID. So I want to remove { }&nbsp; while loading from around 50,000 records and not just for one ID.</P><P></P><P>Thanks,</P><P>H</P></BODY></HTML> Wed, 11 Jul 2012 17:04:01 GMT https://community.qlik.com/t5/QlikView/Trim/m-p/346251#M702580 hkg_qlik 2012-07-11T17:04:01Z Re: Trim https://community.qlik.com/t5/QlikView/Trim/m-p/346252#M702581 <HTML><HEAD></HEAD><BODY><P>Not as efficient as <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/krishnamoorthy" id="jive-3827030458184506878443">krishnamoorthy</A>'s answer, but another way is as follows if it helps..</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; subfield(mid(MEM_ID,2,100),'}',1) as MEM_ID_Clean</SPAN></P><P></P><P>(I assume that there will be no more than 100 characters and the { will always be the first character?):</P><P></P><P>Derek</P></BODY></HTML> Wed, 11 Jul 2012 17:04:21 GMT https://community.qlik.com/t5/QlikView/Trim/m-p/346252#M702581 derekjones 2012-07-11T17:04:21Z Re: Trim https://community.qlik.com/t5/QlikView/Trim/m-p/346253#M702582 <HTML><HEAD></HEAD><BODY><P>Then you should try using</P><P></P><P>PurgeChar(MEM_ID,'{}') as MEM_ID</P><P></P><P>in your load script.</P></BODY></HTML> Wed, 11 Jul 2012 17:07:31 GMT https://community.qlik.com/t5/QlikView/Trim/m-p/346253#M702582 nagaiank 2012-07-11T17:07:31Z