topic Re: How to get number from the text string in QlikView https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96959#M15546 <HTML><HEAD></HEAD><BODY><P>maybe</P><P>if (match(yourfield,'RISK'),keepchar(yourfield,'012345679'))</P></BODY></HTML> Wed, 05 Sep 2018 13:55:35 GMT Anonymous 2018-09-05T13:55:35Z How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96954#M15541 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>Below text i want to get only " 8259075 "number. please help me</P><P></P><P>When combination of RISK i have to display number</P><P></P><P> A wrongful rescission could lead to greater customer expenses incurred and potentially disputes and litigation; all leading to potential regulatory breach and financial loss to the firm. [RISK;8259075;Foreclosure Sales Rescission</P><P></P><P></P><P></P><P></P><P>Thanks in Advance,</P><P>Niranjan</P></BODY></HTML> Wed, 05 Sep 2018 13:41:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96954#M15541 NavinReddy 2018-09-05T13:41:28Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96955#M15542 <HTML><HEAD></HEAD><BODY><P>you want only numbers from text, e.g. 8259075?</P><P>then use keepchar(yourfield,'012345679')</P></BODY></HTML> Wed, 05 Sep 2018 13:43:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96955#M15542 Anonymous 2018-09-05T13:43:52Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96956#M15543 <HTML><HEAD></HEAD><BODY><P>try - PurgeChar(YourFieldName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')</P></BODY></HTML> Wed, 05 Sep 2018 13:45:50 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96956#M15543 neelamsaroha157 2018-09-05T13:45:50Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96957#M15544 <HTML><HEAD></HEAD><BODY><P>When combination of RISK i have to disply number</P></BODY></HTML> Wed, 05 Sep 2018 13:54:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96957#M15544 NavinReddy 2018-09-05T13:54:18Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96958#M15545 <HTML><HEAD></HEAD><BODY><P>When combination of RISK i have to display number</P></BODY></HTML> Wed, 05 Sep 2018 13:54:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96958#M15545 NavinReddy 2018-09-05T13:54:28Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96959#M15546 <HTML><HEAD></HEAD><BODY><P>maybe</P><P>if (match(yourfield,'RISK'),keepchar(yourfield,'012345679'))</P></BODY></HTML> Wed, 05 Sep 2018 13:55:35 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96959#M15546 Anonymous 2018-09-05T13:55:35Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96960#M15547 <HTML><HEAD></HEAD><BODY><P>i got the blank data</P></BODY></HTML> Wed, 05 Sep 2018 14:04:07 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96960#M15547 NavinReddy 2018-09-05T14:04:07Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96961#M15548 <HTML><HEAD></HEAD><BODY><P>sorry,</P><P>this is correct; needed wildmatch and wildcards</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">wildmatch</SPAN><SPAN style="font-size: 8pt;">('RISK;8259075;Foreclosure Sales Rescission (due to Chase error)','*RISK*')&gt;0, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">keepchar</SPAN><SPAN style="font-size: 8pt;">('[RISK;8259075;Foreclosure Sales Rescission (due to Chase error)]','0123456789'),-1) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">instead the string use Name of your field</SPAN></P></BODY></HTML> Wed, 05 Sep 2018 14:09:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96961#M15548 Anonymous 2018-09-05T14:09:41Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96962#M15549 <HTML><HEAD></HEAD><BODY><P>Sorry,</P><P>its actually dynamic data, in the same list i have more than 500 name with same format with different names </P></BODY></HTML> Wed, 05 Sep 2018 14:17:51 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96962#M15549 NavinReddy 2018-09-05T14:17:51Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96963#M15550 <HTML><HEAD></HEAD><BODY><P>500 names in one string? then you should think about dividing These huge number of fata in a string</P><P></P><P>or 500 names in a field?</P><P>if in a field use this in a script:</P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">wildmatch</SPAN><SPAN style="font-size: 8pt;">(yourfiled'*RISK*')&gt;0, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">keepchar</SPAN><SPAN style="font-size: 8pt;">(yourfiled,'0123456789'),-1)&nbsp; as yournewfieldnumber</SPAN></SPAN></P></BODY></HTML> Wed, 05 Sep 2018 14:22:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96963#M15550 Anonymous 2018-09-05T14:22:34Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96964#M15551 <HTML><HEAD></HEAD><BODY><P>500 names in one field</P></BODY></HTML> Wed, 05 Sep 2018 14:41:01 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96964#M15551 NavinReddy 2018-09-05T14:41:01Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96965#M15552 <HTML><HEAD></HEAD><BODY><P>Sorry sir its not working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 05 Sep 2018 14:46:01 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96965#M15552 NavinReddy 2018-09-05T14:46:01Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96966#M15553 <HTML><HEAD></HEAD><BODY><P>If you know (error) number is always in the same fixed number.</P><P></P><P style="font-size: 13.3333px;">TextData:</P><P style="font-size: 13.3333px;">Load</P><P style="font-size: 13.3333px;">SubField(DataT, ';', 2) As NewData</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; ,DataT;</P><P style="font-size: 13.3333px;">Load * Inline</P><P style="font-size: 13.3333px;">[</P><P style="font-size: 13.3333px;">DataT</P><P style="font-size: 13.3333px;">RISK;8259075;Foreclosure Sales Rescission (due to Chase error)</P><P style="font-size: 13.3333px;">];</P></BODY></HTML> Wed, 05 Sep 2018 14:54:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96966#M15553 nsetty 2018-09-05T14:54:30Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96967#M15554 <HTML><HEAD></HEAD><BODY><P>Can you provide a sample of 2 -3 lines of your field and output, as Rudolf's suggestion would work for the example provided.</P><P><SPAN style="color: #800000; font-size: 10pt;"><SPAN style="font-size: 10pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">NUM</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">IF</SPAN><SPAN style="font-size: 10pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">WildMatch</SPAN><SPAN style="font-size: 10pt;">( </SPAN><SPAN style="color: #800000; font-size: 10pt;">YourField</SPAN><SPAN style="font-size: 10pt;">, '*RISK*') , </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">keepchar</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">YourField</SPAN><SPAN style="font-size: 10pt;">,'0123456789'), </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">NULL</SPAN><SPAN style="font-size: 10pt;">())) </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">as</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;">New_Field</SPAN><SPAN style="font-size: 10pt;"> <BR /> </SPAN></SPAN></P></BODY></HTML> Wed, 05 Sep 2018 15:16:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96967#M15554 vamsee 2018-09-05T15:16:54Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96968#M15555 <HTML><HEAD></HEAD><BODY><P>How about:</P><P></P><P>TextBetween(YourField, 'RISK;', ';')</P><P></P><P>-Rob</P></BODY></HTML> Wed, 05 Sep 2018 17:19:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96968#M15555 rwunderlich 2018-09-05T17:19:59Z Re: How to get number from the text string https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96969#M15556 <HTML><HEAD></HEAD><BODY><P>Thank you very much Vamsee its working </P></BODY></HTML> Thu, 06 Sep 2018 05:00:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-number-from-the-text-string/m-p/96969#M15556 NavinReddy 2018-09-06T05:00:00Z