topic Re: Extracting numbers between text. in QlikView https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559817#M687728 <HTML><HEAD></HEAD><BODY><P>Hi, use the function PURGECHAR() or KEEPCHAR()</P><P></P><P>See.</P><P></P><P>PurgeChar('B9867HH','ABCDEFGHIJKLMNOPQRSTUWYVXZ') RESULT IS 9867.</P><P>or</P><P>KeepChar('B9867HH','0123456789') RESULT IS 9867.</P><P></P><P>Best Regards.</P><P>Tonial.</P></BODY></HTML> Thu, 21 Nov 2013 11:58:08 GMT fernando_tonial 2013-11-21T11:58:08Z Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559816#M687727 <HTML><HEAD></HEAD><BODY><P><BR />Hello All,</P><P></P><P>Please help I have to extract number between text.</P><P></P><P>Example: my string contains B1234, B987HH etc I have to write a script to extract only number from the string.</P><P></P><P>String B9867HH to 9867</P><P>String B1234 to 1234</P><P></P><P>Thanks</P></BODY></HTML> Thu, 21 Nov 2013 11:45:37 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559816#M687727 2013-11-21T11:45:37Z Re: Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559817#M687728 <HTML><HEAD></HEAD><BODY><P>Hi, use the function PURGECHAR() or KEEPCHAR()</P><P></P><P>See.</P><P></P><P>PurgeChar('B9867HH','ABCDEFGHIJKLMNOPQRSTUWYVXZ') RESULT IS 9867.</P><P>or</P><P>KeepChar('B9867HH','0123456789') RESULT IS 9867.</P><P></P><P>Best Regards.</P><P>Tonial.</P></BODY></HTML> Thu, 21 Nov 2013 11:58:08 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559817#M687728 fernando_tonial 2013-11-21T11:58:08Z Re: Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559818#M687729 <HTML><HEAD></HEAD><BODY><P>hi try this</P><P><SPAN class="Code">purgechar ( 'a1b2c3','123' ) </SPAN>returns '<SPAN class="Italic">abc</SPAN>'</P><P></P><P>or try this</P><P><SPAN class="Code">purgechar ( 'a1b2c3','abc' ) </SPAN>returns 123</P></BODY></HTML> Thu, 21 Nov 2013 12:03:12 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559818#M687729 2013-11-21T12:03:12Z Re: Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559819#M687731 <HTML><HEAD></HEAD><BODY><P>Thanks a lot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Nov 2013 12:04:54 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559819#M687731 2013-11-21T12:04:54Z Re: Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559820#M687732 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use:</P><P>KeepChar(myCode, '0123456789')</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Thu, 21 Nov 2013 12:06:04 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559820#M687732 jonathandienst 2013-11-21T12:06:04Z Re: Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559821#M687733 <HTML><HEAD></HEAD><BODY><P>Please check QVW</P></BODY></HTML> Thu, 21 Nov 2013 12:06:20 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559821#M687733 saumyashah90 2013-11-21T12:06:20Z Re: Extracting numbers between text. https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559822#M687734 <HTML><HEAD></HEAD><BODY><P>try this</P><P><SPAN class="Code">keepchar ( 'B987HH','12345679' ) </SPAN>returns '<SPAN class="Italic">123'</SPAN></P></BODY></HTML> Thu, 21 Nov 2013 12:07:54 GMT https://community.qlik.com/t5/QlikView/Extracting-numbers-between-text/m-p/559822#M687734 2013-11-21T12:07:54Z