topic Re: Removing spaces between a string. in QlikView https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522464#M195206 <HTML><HEAD></HEAD><BODY><P>purgechar([Your Field], ' ')</P></BODY></HTML> Fri, 28 Jun 2013 18:34:10 GMT Nicole-Smith 2013-06-28T18:34:10Z Removing spaces between a string. https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522463#M195205 <HTML><HEAD></HEAD><BODY><P>Hi There, </P><P></P><P>I am trying to remove spaces between the below string . Can anyone help me how should i do it?</P><P></P><P>I tried the trim functions and the same does not work </P><P></P><P>Origional data :&nbsp;&nbsp;&nbsp; CGB0 024425 </P><P>Exoected result:&nbsp;&nbsp; CGB0024425</P><P></P><P>Thanks for your help in advance</P><P></P><P>Regards,</P><P>Viral </P></BODY></HTML> Fri, 28 Jun 2013 18:29:44 GMT https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522463#M195205 2013-06-28T18:29:44Z Re: Removing spaces between a string. https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522464#M195206 <HTML><HEAD></HEAD><BODY><P>purgechar([Your Field], ' ')</P></BODY></HTML> Fri, 28 Jun 2013 18:34:10 GMT https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522464#M195206 Nicole-Smith 2013-06-28T18:34:10Z Re: Removing spaces between a string. https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522465#M195207 <HTML><HEAD></HEAD><BODY><P>Hi Nicole, </P><P></P><P>I tried purgechar , but it does not work </P><P></P><P>Thx </P><P>Viral </P></BODY></HTML> Fri, 28 Jun 2013 18:35:42 GMT https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522465#M195207 2013-06-28T18:35:42Z Re: Removing spaces between a string. https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522466#M195208 <HTML><HEAD></HEAD><BODY><P>You can try replace too: <SPAN style="font-size: 10pt;">replace(MyField, ' ','')</SPAN></P><P></P><P>But purgechar works fine for me. For example =PurgeChar('CGB0 024425',' ') returns CGB0024425. </P></BODY></HTML> Fri, 28 Jun 2013 18:37:28 GMT https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522466#M195208 Gysbert_Wassenaar 2013-06-28T18:37:28Z Re: Removing spaces between a string. https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522467#M195209 <HTML><HEAD></HEAD><BODY><P>Can you post a .qvw?&nbsp; There is no reason why it shouldn't work...</P></BODY></HTML> Fri, 28 Jun 2013 18:37:35 GMT https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522467#M195209 Nicole-Smith 2013-06-28T18:37:35Z Re: Removing spaces between a string. https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522468#M195210 <HTML><HEAD></HEAD><BODY><P>Thanks This works <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 28 Jun 2013 18:39:28 GMT https://community.qlik.com/t5/QlikView/Removing-spaces-between-a-string/m-p/522468#M195210 2013-06-28T18:39:28Z