topic remove the spaces in QlikView https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398044#M148234 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>how can I write the script, if i want to remove the spaces in the field?</P><P>Example:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="138" style="border: 1px solid rgb(0, 0, 0); width: 88px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">Field</TH></TR><TR><TD>(London&nbsp;&nbsp;&nbsp; )</TD></TR><TR><TD>(London)</TD></TR><TR><TD>(Paris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</TD></TR><TR><TD>(Paris)</TD></TR></TBODY></TABLE><P></P><P>Many thanks</P></BODY></HTML> Wed, 27 Mar 2013 09:15:05 GMT andyrebs 2013-03-27T09:15:05Z remove the spaces https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398044#M148234 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>how can I write the script, if i want to remove the spaces in the field?</P><P>Example:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="138" style="border: 1px solid rgb(0, 0, 0); width: 88px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">Field</TH></TR><TR><TD>(London&nbsp;&nbsp;&nbsp; )</TD></TR><TR><TD>(London)</TD></TR><TR><TD>(Paris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</TD></TR><TR><TD>(Paris)</TD></TR></TBODY></TABLE><P></P><P>Many thanks</P></BODY></HTML> Wed, 27 Mar 2013 09:15:05 GMT https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398044#M148234 andyrebs 2013-03-27T09:15:05Z Re: remove the spaces https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398045#M148235 <HTML><HEAD></HEAD><BODY><P>Hi Andy,</P><P></P><P>Use below code.</P><P></P><P><SPAN style="color: #800080; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #800080; font-size: 8pt;">&nbsp; </SPAN></P><P>text<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800080; font-size: 8pt;">trim</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800080; font-size: 8pt;">purgechar</SPAN><SPAN style="font-size: 8pt;">(Field</SPAN><SPAN style="font-size: 8pt;">, ' '))) </SPAN></P></BODY></HTML> Wed, 27 Mar 2013 09:24:36 GMT https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398045#M148235 2013-03-27T09:24:36Z Re: remove the spaces https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398046#M148236 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Trim(Subfield(FieldName,')',1))&amp;')' as FieldName</P><P></P><P>It might helps you.</P><P></P><P>Best of luck</P></BODY></HTML> Wed, 27 Mar 2013 09:25:32 GMT https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398046#M148236 2013-03-27T09:25:32Z Re: remove the spaces https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398047#M148237 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>have you tried TRIM function ?</P><P></P><P>Load *,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Trim(Field) as FieldTrim</P><P>From ....</P><P></P><P>Hope it helps</P><P>Giampiero</P></BODY></HTML> Wed, 27 Mar 2013 09:25:43 GMT https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398047#M148237 2013-03-27T09:25:43Z Re: remove the spaces https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398048#M148238 <HTML><HEAD></HEAD><BODY><DIV>Hi in the script write</DIV><DIV> </DIV><DIV>LOAD</DIV><DIV><SPAN style="font-size: 10pt; font-family: CourierNewPSMT;"><DIV>trim (field) as newfield</DIV>from...</SPAN></DIV></BODY></HTML> Wed, 27 Mar 2013 09:29:24 GMT https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398048#M148238 2013-03-27T09:29:24Z Re: remove the spaces https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398049#M148239 <HTML><HEAD></HEAD><BODY><P>Many Thanks</P></BODY></HTML> Wed, 27 Mar 2013 17:43:22 GMT https://community.qlik.com/t5/QlikView/remove-the-spaces/m-p/398049#M148239 andyrebs 2013-03-27T17:43:22Z