topic Re: Hi everyone in QlikView https://community.qlik.com/t5/QlikView/Hi-everyone/m-p/96328#M602157 <HTML><HEAD></HEAD><BODY><P>replace([Order Numbers],' ','-') as Whatever</P></BODY></HTML> Fri, 21 Sep 2018 16:32:50 GMT m_woolf 2018-09-21T16:32:50Z Hi everyone https://community.qlik.com/t5/QlikView/Hi-everyone/m-p/96327#M602156 <HTML><HEAD></HEAD><BODY><P>I have a long and always changing list of Order Numbers, (example : <SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;">ORD 0017906713)</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;">I need to replace the space and put '-' instead. I'm currently struggling as the replace function will ask me to put a specific term to substitute with a new one. </SPAN></P><P><SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;">I hope that makes sense (ps: excuse my poor english)</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;">Thank you in advance, </SPAN></P><P><SPAN style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px;">Michela<BR /></SPAN></P></BODY></HTML> Fri, 21 Sep 2018 10:51:13 GMT https://community.qlik.com/t5/QlikView/Hi-everyone/m-p/96327#M602156 Anonymous 2018-09-21T10:51:13Z Re: Hi everyone https://community.qlik.com/t5/QlikView/Hi-everyone/m-p/96328#M602157 <HTML><HEAD></HEAD><BODY><P>replace([Order Numbers],' ','-') as Whatever</P></BODY></HTML> Fri, 21 Sep 2018 16:32:50 GMT https://community.qlik.com/t5/QlikView/Hi-everyone/m-p/96328#M602157 m_woolf 2018-09-21T16:32:50Z