topic Only retrieve text data from a field and remove all # in QlikView https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409498#M700546 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can I remove in a script, any numbers from a text field, regardless if the numbers are in the beginning, middle, or end of the text string?</P><P></P><P>An examble would be </P><P></P><P>123abc789 = abc</P><P>5dfg7246 = dfg</P><P>athu8979761 = athu&nbsp;&nbsp; </P><P></P><P>Thanks!</P><P>Jen</P></BODY></HTML> Fri, 12 Oct 2012 15:34:29 GMT Anonymous 2012-10-12T15:34:29Z Only retrieve text data from a field and remove all # https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409498#M700546 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can I remove in a script, any numbers from a text field, regardless if the numbers are in the beginning, middle, or end of the text string?</P><P></P><P>An examble would be </P><P></P><P>123abc789 = abc</P><P>5dfg7246 = dfg</P><P>athu8979761 = athu&nbsp;&nbsp; </P><P></P><P>Thanks!</P><P>Jen</P></BODY></HTML> Fri, 12 Oct 2012 15:34:29 GMT https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409498#M700546 Anonymous 2012-10-12T15:34:29Z Re: Only retrieve text data from a field and remove all # https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409499#M700547 <HTML><HEAD></HEAD><BODY><P>This should do the trick:&nbsp; purgechar(MyField, '0123456789') </P></BODY></HTML> Fri, 12 Oct 2012 16:00:43 GMT https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409499#M700547 Gysbert_Wassenaar 2012-10-12T16:00:43Z Re: Only retrieve text data from a field and remove all # https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409500#M700548 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 12 Oct 2012 16:09:11 GMT https://community.qlik.com/t5/QlikView/Only-retrieve-text-data-from-a-field-and-remove-all/m-p/409500#M700548 Anonymous 2012-10-12T16:09:11Z