topic Trim like? in QlikView https://community.qlik.com/t5/QlikView/Trim-like/m-p/194224#M55207 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I'm looking for a function:</P><P>my data is in this format: 32-GH-47 and i would like to quit the '-' caracter.</P><P>As well, how do i quit the space in a middle of '26 AK 25' ?</P><P>Thanks</P></BODY></HTML> Fri, 01 Apr 2011 10:02:37 GMT 2011-04-01T10:02:37Z Trim like? https://community.qlik.com/t5/QlikView/Trim-like/m-p/194224#M55207 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I'm looking for a function:</P><P>my data is in this format: 32-GH-47 and i would like to quit the '-' caracter.</P><P>As well, how do i quit the space in a middle of '26 AK 25' ?</P><P>Thanks</P></BODY></HTML> Fri, 01 Apr 2011 10:02:37 GMT https://community.qlik.com/t5/QlikView/Trim-like/m-p/194224#M55207 2011-04-01T10:02:37Z Trim like? https://community.qlik.com/t5/QlikView/Trim-like/m-p/194225#M55208 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see QV help and look for PURGECHAR</P><P style="margin-left:40px;">purgechar ( 'a1b2c3','123' ) and you will get 'abc'</P><P style="margin-left:40px;">Good luck!</P><P style="margin-left:40px;">Rainer</P></BODY></HTML> Fri, 01 Apr 2011 10:09:47 GMT https://community.qlik.com/t5/QlikView/Trim-like/m-p/194225#M55208 2011-04-01T10:09:47Z Trim like? https://community.qlik.com/t5/QlikView/Trim-like/m-p/194226#M55209 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Fri, 01 Apr 2011 10:18:03 GMT https://community.qlik.com/t5/QlikView/Trim-like/m-p/194226#M55209 2011-04-01T10:18:03Z