topic 30 Days to 30 in QlikView https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54878#M782472 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have data, "PaymentPeriod" coded as '30 days' or '43 days'.</P><P></P><P>How can I load this data so that I only get 30 or 43.</P><P></P><P>If I know the content I would do it like this:</P><P></P><P><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;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PaymentPeriod</SPAN><SPAN style="font-size: 8pt;">,'*30*'),30, if(...))</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">However, I will have many payment periods. The approach above is not feasible. Is there a function that recognizes the number part of the data element which helps me to extract this part?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Many thanks.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Jan</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT schumi1980 2020-11-25T16:16:04Z 30 Days to 30 https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54878#M782472 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have data, "PaymentPeriod" coded as '30 days' or '43 days'.</P><P></P><P>How can I load this data so that I only get 30 or 43.</P><P></P><P>If I know the content I would do it like this:</P><P></P><P><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;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PaymentPeriod</SPAN><SPAN style="font-size: 8pt;">,'*30*'),30, if(...))</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">However, I will have many payment periods. The approach above is not feasible. Is there a function that recognizes the number part of the data element which helps me to extract this part?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Many thanks.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Jan</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54878#M782472 schumi1980 2020-11-25T16:16:04Z Re: 30 Days to 30 https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54879#M782473 <HTML><HEAD></HEAD><BODY><P>Try KeepChar(StrName, Chr you want to extract)</P></BODY></HTML> Tue, 20 Mar 2018 09:36:45 GMT https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54879#M782473 shiveshsingh 2018-03-20T09:36:45Z Re: 30 Days to 30 https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54880#M782474 <HTML><HEAD></HEAD><BODY><P>If(Keepchar(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PaymentPeriod</SPAN>,'0123456789')=30</P></BODY></HTML> Tue, 20 Mar 2018 09:46:30 GMT https://community.qlik.com/t5/QlikView/30-Days-to-30/m-p/54880#M782474 sasiparupudi1 2018-03-20T09:46:30Z