topic Re: return specific values in QlikView https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239945#M393918 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P><STRONG>LOAD KeepChar(values,'/0123456789') as values Inline [</STRONG></P><P><STRONG>values</STRONG></P><P><STRONG>abcde1/2/3</STRONG></P><P><STRONG>adb2/4/5</STRONG></P><P><STRONG>abcdefg0/1</STRONG></P><P><STRONG>];</STRONG></P></BODY></HTML> Tue, 07 Mar 2017 06:02:56 GMT Anil_Babu_Samineni 2017-03-07T06:02:56Z return specific values https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239944#M393917 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Anyone with an easy way to return the following specific values from the list below?</P><P></P><P><STRONG>values:</STRONG><BR />abcde1/2/3<BR />adb2/4/5<BR />abcdefg0/1</P><P><BR /><STRONG>expected result</STRONG><BR />1/2/3<BR />2/4/5<BR />0/1</P><P></P><P></P><P>In short I just want to purge all alphabets and keep the rest including the slashes.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 07 Mar 2017 06:00:36 GMT https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239944#M393917 didierodayo 2017-03-07T06:00:36Z Re: return specific values https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239945#M393918 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P><STRONG>LOAD KeepChar(values,'/0123456789') as values Inline [</STRONG></P><P><STRONG>values</STRONG></P><P><STRONG>abcde1/2/3</STRONG></P><P><STRONG>adb2/4/5</STRONG></P><P><STRONG>abcdefg0/1</STRONG></P><P><STRONG>];</STRONG></P></BODY></HTML> Tue, 07 Mar 2017 06:02:56 GMT https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239945#M393918 Anil_Babu_Samineni 2017-03-07T06:02:56Z Re: return specific values https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239946#M393919 <HTML><HEAD></HEAD><BODY><P>Perfect Anil that will work. Thanks</P></BODY></HTML> Tue, 07 Mar 2017 06:16:07 GMT https://community.qlik.com/t5/QlikView/return-specific-values/m-p/1239946#M393919 didierodayo 2017-03-07T06:16:07Z