topic Removeing character values from alphanumeric field in QlikView https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177019#M44792 <HTML><HEAD></HEAD><BODY><P>Hi Sharma</P><P>you can use either purgechar or keepchar functions in qv here is the code for tht</P><P>keepchar(Dept_Id,1234567890) as Dept_Id ..</P><P>This will remove alphabets and keep the numbers</P><P></P></BODY></HTML> Thu, 20 Jan 2011 12:41:50 GMT 2011-01-20T12:41:50Z Removeing character values from alphanumeric field https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177018#M44791 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hi Community,</P><P style="margin: 0in 0in 10pt;">I have a problem with the alphanumeric values coming from the field. I want to remove character values from this field and retain only the numeric part of it.</P><P style="margin: 0in 0in 10pt;">For example, I have a field say <B style="mso-bidi-font-weight: normal;">Dept_Id.</B> Below are the values coming out of it.</P><P style="margin: 0in 0in 10pt;">AA23546</P><P style="margin: 0in 0in 10pt;">SAT66458</P><P style="margin: 0in 0in 10pt;">J646578</P><P style="margin: 0in 0in 10pt;">BDYU15</P><P style="margin: 0in 0in 10pt;">etc.</P><P style="margin: 0in 0in 10pt;">I want to have the values like 23546,66458,646578,15 out of the above values. Please note that number of characters are varying.</P><P style="margin: 0in 0in 10pt;">Any help is very much appreciated.</P><P style="margin: 0in 0in 10pt;"></P></BODY></HTML> Thu, 20 Jan 2011 12:25:36 GMT https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177018#M44791 montubhardwaj 2011-01-20T12:25:36Z Removeing character values from alphanumeric field https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177019#M44792 <HTML><HEAD></HEAD><BODY><P>Hi Sharma</P><P>you can use either purgechar or keepchar functions in qv here is the code for tht</P><P>keepchar(Dept_Id,1234567890) as Dept_Id ..</P><P>This will remove alphabets and keep the numbers</P><P></P></BODY></HTML> Thu, 20 Jan 2011 12:41:50 GMT https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177019#M44792 2011-01-20T12:41:50Z Removeing character values from alphanumeric field https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177020#M44793 <HTML><HEAD></HEAD><BODY><P>Perfect Surendar. Many thanks.</P></BODY></HTML> Thu, 20 Jan 2011 13:07:44 GMT https://community.qlik.com/t5/QlikView/Removeing-character-values-from-alphanumeric-field/m-p/177020#M44793 montubhardwaj 2011-01-20T13:07:44Z