topic Re: Delete a Space from Value in QlikView https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813432#M1023506 <HTML><HEAD></HEAD><BODY><P>Try</P><P>replace(NAME, ' ,', ',')</P></BODY></HTML> Mon, 16 Mar 2015 19:24:08 GMT Anonymous 2015-03-16T19:24:08Z Delete a Space from Value https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813431#M1023505 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a field with NAME where I could get from data:</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">JOHNSON , JACK (with space after lastname)</SPAN></P><P>JOHNSON, JACK</P><P></P><P>Is there any way to use a function in <SPAN style="font-size: 13.3333330154419px;">JOHNSON , JACK in order to delete that space?</SPAN></P><P></P><P>Thank you!</P></BODY></HTML> Mon, 16 Mar 2015 19:21:40 GMT https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813431#M1023505 microwin88x 2015-03-16T19:21:40Z Re: Delete a Space from Value https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813432#M1023506 <HTML><HEAD></HEAD><BODY><P>Try</P><P>replace(NAME, ' ,', ',')</P></BODY></HTML> Mon, 16 Mar 2015 19:24:08 GMT https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813432#M1023506 Anonymous 2015-03-16T19:24:08Z Re: Delete a Space from Value https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813433#M1023507 <HTML><HEAD></HEAD><BODY><P>replace function</P><P></P><P></P><P>=replace('JOHNSON , JACK', ' ,', ',')</P></BODY></HTML> Mon, 16 Mar 2015 19:25:46 GMT https://community.qlik.com/t5/QlikView/Delete-a-Space-from-Value/m-p/813433#M1023507 maxgro 2015-03-16T19:25:46Z