topic Delete space in data in QlikView https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281421#M707015 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this </P><P></P><P> =PurgeChar( ColumnName , ' ' )</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 06 Dec 2011 09:01:11 GMT jagan 2011-12-06T09:01:11Z Delete space in data https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281419#M707013 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In one of my fields, i have data like 'AAAA&nbsp; BB CC' or 'AAA BB CCC' and i want them as 'AAABBBCC' and ' AAABBCCC'.</P><P></P><P>How can i do that ?</P></BODY></HTML> Tue, 06 Dec 2011 08:54:20 GMT https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281419#M707013 christophebrault 2011-12-06T08:54:20Z Delete space in data https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281420#M707014 <HTML><HEAD></HEAD><BODY><P>Hi, use the Replace() Function, like:</P><P></P><P>replace(field, ' ', '').</P><P></P><P></P><P>Hope this helps you.</P><P>Regards,</P><P>Fernando</P></BODY></HTML> Tue, 06 Dec 2011 08:59:01 GMT https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281420#M707014 fosuzuki 2011-12-06T08:59:01Z Delete space in data https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281421#M707015 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this </P><P></P><P> =PurgeChar( ColumnName , ' ' )</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 06 Dec 2011 09:01:11 GMT https://community.qlik.com/t5/QlikView/Delete-space-in-data/m-p/281421#M707015 jagan 2011-12-06T09:01:11Z