topic String functions in QlikView https://community.qlik.com/t5/QlikView/String-functions/m-p/207985#M63547 <HTML><HEAD></HEAD><BODY><P>use Mid() function instead of TextBetween(). see in my example...</P></BODY></HTML> Wed, 30 Jun 2010 09:18:22 GMT sparur 2010-06-30T09:18:22Z String functions https://community.qlik.com/t5/QlikView/String-functions/m-p/207982#M63544 <HTML><HEAD></HEAD><BODY><P style="margin: 0mm 0mm 0pt;">Hello,</P><P style="margin: 0mm 0mm 0pt;">I try to map the QVW files which I use on the server.</P><P style="margin: 0mm 0mm 0pt;">I read the log files and try to extract data from it.</P><P style="margin: 0mm 0mm 0pt;">For example, I have the following lines:</P><P style="margin: 0mm 0mm 0pt;"></P><P style="margin: 0mm 0mm 0pt;">0022 FROM ..\..\QVD\R3_TABLE\MARA.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0032 FROM ..\..\QVD\R3_TABLE\MAKT.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0040 FROM ..\..\QVD\R3_TABLE\T023T.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0046 FROM <A>\\aaa.com\fs3\SAP\QV\QlikView\Apps\LoadTables\QVD\Planet\Open_Period.qvd</A> (qvd)</P><P style="margin: 0mm 0mm 0pt;">0049 FROM ..\..\QVD\R3_TABLE\ZMM_PRDGRPT.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0055 FROM <A>\\aaa.com\fs3\SAP\QV\QlikView\Apps\LoadTables\QVD\Planet\Planet.qvd</A> (qvd)</P><P style="margin: 0mm 0mm 0pt;">0073 FROM <A>\\aaa.com\fs3\SAP\QV\QlikView\Apps\QVD\QVD_Text_table\TCOMPANY.QVD</A> (qvd)</P><P style="margin: 0mm 0mm 0pt;">0124 FROM ..\Collection\Update_Details.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0130 FROM ..\Capacity\Update_Details.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0142 load * from QVD\KPI_aF.qvd (qvd)</P><P style="margin: 0mm 0mm 0pt;">0144 FROM ..\OTDProductiontoSC\QVD\Update.qvd (qvd)</P><P style="margin: 0mm 0mm 0pt;">0151 FROM ..\ProductionKPI\QVD\Update.qvd (qvd)</P><P style="margin: 0mm 0mm 0pt;">0156 FROM ..\..\QVD\R3_TABLE\NAST.QVD (qvd) where VSTAT=1</P><P style="margin: 0mm 0mm 0pt;">0156 FROM ..\Collection\Update_Details.QVD (qvd)</P><P style="margin: 0mm 0mm 0pt;">0166 FROM ..\Finance\QVD\Update.qvd (qvd)</P><P style="margin: 0mm 0mm 0pt;"></P><P style="margin: 0mm 0mm 0pt;">I'm trying to get all information between the last "" and ".QVD" or "qvd"</P><P style="margin: 0mm 0mm 0pt;">I tried the following script:</P><P style="margin: 0mm 0mm 0pt;"></P><P style="margin: 0mm 0mm 0pt;">Purgechar(TextBetween(@4, '', 'qvd',(substringcount (@4, '' ))),'. QVD (') &amp; '. qvd' <B>as</B> Table,</P><P style="margin: 0mm 0mm 0pt;"></P><P style="margin: 0mm 0mm 0pt;"></P><P style="margin: 0mm 0mm 0pt;">But the result is that the files arrive without the letters Q, V and D.</P><P style="margin: 0mm 0mm 0pt;">Thanks in advance for your help</P><P style="margin: 0mm 0mm 0pt;">Elad</P></BODY></HTML> Wed, 30 Jun 2010 07:59:34 GMT https://community.qlik.com/t5/QlikView/String-functions/m-p/207982#M63544 2010-06-30T07:59:34Z String functions https://community.qlik.com/t5/QlikView/String-functions/m-p/207983#M63545 <HTML><HEAD></HEAD><BODY><P>Hello, Elad.</P><P>see in my example...</P><P></P></BODY></HTML> Wed, 30 Jun 2010 08:36:11 GMT https://community.qlik.com/t5/QlikView/String-functions/m-p/207983#M63545 sparur 2010-06-30T08:36:11Z String functions https://community.qlik.com/t5/QlikView/String-functions/m-p/207984#M63546 <HTML><HEAD></HEAD><BODY><P style="margin:0mm 0mm 0pt;">Hello,</P><P style="margin:0mm 0mm 0pt;">Thank you for your answer</P><P style="margin:0mm 0mm 0pt;">Now I try to enter all this parts to one script.</P><P style="margin:0mm 0mm 0pt;">This is my script:</P><P style="margin:0mm 0mm 0pt;mso-layout-grid-align:none;">TextBetween('@4',(text( index('@4', '\', substringcount('@4', '\')) + 1)),(text(index(upper('@4'), '.QVD')-1))) <B>as</B> Table,</P><P style="margin:0mm 0mm 0pt;"></P><P style="margin:0mm 0mm 0pt;">Without any result</P><P style="margin:0mm 0mm 0pt;">Do you know what is the problem?</P><P style="margin:0mm 0mm 0pt;"></P><P style="margin:0mm 0mm 0pt;">Thank you again</P><P style="margin:0mm 0mm 0pt;">Elad</P></BODY></HTML> Wed, 30 Jun 2010 09:13:20 GMT https://community.qlik.com/t5/QlikView/String-functions/m-p/207984#M63546 2010-06-30T09:13:20Z String functions https://community.qlik.com/t5/QlikView/String-functions/m-p/207985#M63547 <HTML><HEAD></HEAD><BODY><P>use Mid() function instead of TextBetween(). see in my example...</P></BODY></HTML> Wed, 30 Jun 2010 09:18:22 GMT https://community.qlik.com/t5/QlikView/String-functions/m-p/207985#M63547 sparur 2010-06-30T09:18:22Z String functions https://community.qlik.com/t5/QlikView/String-functions/m-p/207986#M63548 <HTML><HEAD></HEAD><BODY><P>Many thanks</P><P>Its look graet now.</P><P>Elad</P></BODY></HTML> Wed, 30 Jun 2010 09:48:52 GMT https://community.qlik.com/t5/QlikView/String-functions/m-p/207986#M63548 2010-06-30T09:48:52Z