topic How replace/substitue in QlikView https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361160#M134110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Check with KeepChar function</P><P>&nbsp;&nbsp;&nbsp;&nbsp; KeepChar(FieldName,'0123456789')</P><P></P><P>Celambarasan</P></BODY></HTML> Fri, 20 Apr 2012 10:50:39 GMT CELAMBARASAN 2012-04-20T10:50:39Z How replace/substitue https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361159#M134109 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a csv file with a Telephone field filled as below:</P><P></P><P>PhoneNumber</P><P>02/0383838</P><P>010 0983823</P><P>08 - 0292827</P><P>...</P><P>I would like to load the filed as </P><P></P><P>PhoneNumber</P><P>020383838</P><P>0100983823</P><P>080292827</P><P>..</P><P></P><P>Thanks</P><P></P><P>Andrea</P></BODY></HTML> Fri, 20 Apr 2012 10:40:46 GMT https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361159#M134109 andyrebs 2012-04-20T10:40:46Z How replace/substitue https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361160#M134110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Check with KeepChar function</P><P>&nbsp;&nbsp;&nbsp;&nbsp; KeepChar(FieldName,'0123456789')</P><P></P><P>Celambarasan</P></BODY></HTML> Fri, 20 Apr 2012 10:50:39 GMT https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361160#M134110 CELAMBARASAN 2012-04-20T10:50:39Z How replace/substitue https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361161#M134111 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P></P><P>I have seen also this discussion</P><P></P><P><A href="https://community.qlik.com/thread/6345">Phone numbers on different formats. How to match?</A></P><P></P><P>Thank you!</P></BODY></HTML> Fri, 20 Apr 2012 11:21:07 GMT https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361161#M134111 andyrebs 2012-04-20T11:21:07Z Re: How replace/substitue https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361162#M134112 <HTML><HEAD></HEAD><BODY><P>check this one</P><P></P><P>phone number </P><P>02/0383838</P><P>010 0983823'</P><P>08 - 0292827'</P><P></P><P>what if there is single code like above one. how could we avoid ..</P></BODY></HTML> Sun, 25 Nov 2012 14:31:37 GMT https://community.qlik.com/t5/QlikView/How-replace-substitue/m-p/361162#M134112 2012-11-25T14:31:37Z