topic Re: my filed data = USD300 , how to read only 300 ? in QlikView https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561584#M209602 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use </P><P>purgechar ( LIST_PRICE,'USD' )</P><P></P><P>or </P><P>=Replace( LIST_PRICE,'USD', '' )</P><P></P><P>Regards,</P><P>Jagan</P></BODY></HTML> Tue, 03 Sep 2013 05:08:47 GMT jagan 2013-09-03T05:08:47Z my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561581#M209599 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>My raw data price list is string , i need to read only the number , can some one give me the script.</P><P></P><P>Now my script is like this , it will read USD300 :-</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; [List Price] AS LIST_PRICE,</P><P></P><P>Paul</P></BODY></HTML> Tue, 03 Sep 2013 04:58:40 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561581#M209599 2013-09-03T04:58:40Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561582#M209600 <HTML><HEAD></HEAD><BODY><P>use Subfield(LIST_PRICE,'USD',2)</P><P></P><P>OR </P><P></P><P>purgechar ( LIST_PRICE,'USD' )</P></BODY></HTML> Tue, 03 Sep 2013 05:05:24 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561582#M209600 2013-09-03T05:05:24Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561583#M209601 <HTML><HEAD></HEAD><BODY><P>use num function</P><P>num([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">LISTPRICE</SPAN>]) as [LIST_PRICE] </P></BODY></HTML> Tue, 03 Sep 2013 05:07:36 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561583#M209601 er_mohit 2013-09-03T05:07:36Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561584#M209602 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use </P><P>purgechar ( LIST_PRICE,'USD' )</P><P></P><P>or </P><P>=Replace( LIST_PRICE,'USD', '' )</P><P></P><P>Regards,</P><P>Jagan</P></BODY></HTML> Tue, 03 Sep 2013 05:08:47 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561584#M209602 jagan 2013-09-03T05:08:47Z Re: Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561585#M209603 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"><STRONG style="font-size: 12pt;">Hi,</STRONG></SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><STRONG>This will work simply</STRONG></SPAN></P><P><SPAN style="font-size: 12pt;"><STRONG>=<SPAN style="color: #0000ff;">Mid</SPAN>('USD300',4) </STRONG></SPAN></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P><SPAN style="font-size: 12pt;"><STRONG>Regards,</STRONG></SPAN></P><P><SPAN><SPAN><STRONG style="font-size: 12pt;">Saritha xavier</STRONG></SPAN></SPAN></P></BODY></HTML> Tue, 03 Sep 2013 05:27:10 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561585#M209603 2013-09-03T05:27:10Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561586#M209604 <HTML><HEAD></HEAD><BODY><P>Both work fine Shi Thank a lot</P></BODY></HTML> Tue, 03 Sep 2013 05:30:07 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561586#M209604 2013-09-03T05:30:07Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561587#M209605 <HTML><HEAD></HEAD><BODY><P>This not able to work. Thank you too for trying.</P></BODY></HTML> Tue, 03 Sep 2013 05:30:34 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561587#M209605 2013-09-03T05:30:34Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561588#M209606 <HTML><HEAD></HEAD><BODY><P>you even better Jagan , you dare to try replace.</P></BODY></HTML> Tue, 03 Sep 2013 05:33:29 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561588#M209606 2013-09-03T05:33:29Z Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561589#M209607 <HTML><HEAD></HEAD><BODY><P>Hi Sar</P><P></P><P>I doubt your will work , as in your script there it no List Price.</P><P></P><P>Paul</P></BODY></HTML> Tue, 03 Sep 2013 05:34:50 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561589#M209607 2013-09-03T05:34:50Z Re: Re: my filed data = USD300 , how to read only 300 ? https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561590#M209608 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>new:</P><P><SPAN style="font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">load</STRONG></STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">mid</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">LISTPRICE</SPAN><SPAN style="font-size: 8pt;">,4)</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">PRICE</SPAN><SPAN style="font-size: 8pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Resident</SPAN><SPAN style="font-size: 8pt;"> USD; </SPAN></SPAN></P></BODY></HTML> Tue, 03 Sep 2013 05:46:27 GMT https://community.qlik.com/t5/QlikView/my-filed-data-USD300-how-to-read-only-300/m-p/561590#M209608 2013-09-03T05:46:27Z