topic Delette Spaces in QlikView https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257152#M97207 <HTML><HEAD></HEAD><BODY><P>How can I delette spaces when I´m Loading some info?</P><P></P><P>For example I have a table with the following fileld:</P><P></P><P>1 2 3</P><P>a a a</P><P></P><P>And I want to load:</P><P></P><P>123</P><P>aaa</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 08 Aug 2011 21:25:12 GMT camilo 2011-08-08T21:25:12Z Delette Spaces https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257152#M97207 <HTML><HEAD></HEAD><BODY><P>How can I delette spaces when I´m Loading some info?</P><P></P><P>For example I have a table with the following fileld:</P><P></P><P>1 2 3</P><P>a a a</P><P></P><P>And I want to load:</P><P></P><P>123</P><P>aaa</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 08 Aug 2011 21:25:12 GMT https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257152#M97207 camilo 2011-08-08T21:25:12Z Delette Spaces https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257153#M97208 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>You can use the Replace function...</P><P></P><P>Replace(FieldName, ' ', '')</P><P></P><P>PurgeChar() might do it as well.</P><P></P><P>Mike</P></BODY></HTML> Mon, 08 Aug 2011 21:27:06 GMT https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257153#M97208 mike_garcia 2011-08-08T21:27:06Z Delette Spaces https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257154#M97209 <HTML><HEAD></HEAD><BODY><P>Thanks, Replace did the work!!</P></BODY></HTML> Mon, 08 Aug 2011 21:48:07 GMT https://community.qlik.com/t5/QlikView/Delette-Spaces/m-p/257154#M97209 camilo 2011-08-08T21:48:07Z