topic Re: Logic needed to seperate text characters from a alphanumeric value in QlikView https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764593#M1024772 <HTML><HEAD></HEAD><BODY><P>purgechar(MyText, '0123456789')</P></BODY></HTML> Mon, 09 Mar 2015 08:55:27 GMT Gysbert_Wassenaar 2015-03-09T08:55:27Z Logic needed to seperate text characters from a alphanumeric value https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764592#M1024771 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a field/column consists of User Names with the addition of numericals.</P><P> Ex: "abc12", "12abcd","aavv"</P><P></P><P>Note: Text is variable length and can present anywhere in the field as shown in example.</P><P>Now i need to seperate text only.</P><P>How i can achieve this?</P><P></P><P>Thanks in advance</P><P></P><P><BR /> </P></BODY></HTML> Mon, 09 Mar 2015 08:54:56 GMT https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764592#M1024771 2015-03-09T08:54:56Z Re: Logic needed to seperate text characters from a alphanumeric value https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764593#M1024772 <HTML><HEAD></HEAD><BODY><P>purgechar(MyText, '0123456789')</P></BODY></HTML> Mon, 09 Mar 2015 08:55:27 GMT https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764593#M1024772 Gysbert_Wassenaar 2015-03-09T08:55:27Z Re: Logic needed to seperate text characters from a alphanumeric value https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764594#M1024773 <HTML><HEAD></HEAD><BODY><P>Try Keepchar()/purgechar()</P></BODY></HTML> Mon, 09 Mar 2015 08:57:45 GMT https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764594#M1024773 tresB 2015-03-09T08:57:45Z Re: Logic needed to seperate text characters from a alphanumeric value https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764595#M1024774 <HTML><HEAD></HEAD><BODY><P>Thankyou </P></BODY></HTML> Mon, 09 Mar 2015 09:03:10 GMT https://community.qlik.com/t5/QlikView/Logic-needed-to-seperate-text-characters-from-a-alphanumeric/m-p/764595#M1024774 2015-03-09T09:03:10Z