topic String Function similar to subfield in QlikView https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535542#M200110 <HTML><HEAD></HEAD><BODY><P>I've got the following values in a field call "Document"</P><P></P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\april13 month end report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\december12 month end report r5.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\june13 month end report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\june13 reconciliation report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\reloading monitor.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\variance report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\monitors\qv10systemmonitor.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\qv10systemmonitor.qvw</P><P></P><P>I've used the following as a dimension in a chart to get just the filename and not the full path:</P><P></P><P>=subfield(Document,'\',10)</P><P></P><P>This works for all the Documents with the following path:</P><P></P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\</P><P></P><P>....but not the others. Is there a similar function I can use to extract the file name from right to left (instead of left to right) picking anything to the right of the "\" on the far right?</P></BODY></HTML> Mon, 29 Jul 2013 14:45:52 GMT shane_spencer 2013-07-29T14:45:52Z String Function similar to subfield https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535542#M200110 <HTML><HEAD></HEAD><BODY><P>I've got the following values in a field call "Document"</P><P></P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\april13 month end report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\december12 month end report r5.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\june13 month end report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\june13 reconciliation report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\reloading monitor.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\variance report r7a.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\monitors\qv10systemmonitor.qvw</P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\qv10systemmonitor.qvw</P><P></P><P>I've used the following as a dimension in a chart to get just the filename and not the full path:</P><P></P><P>=subfield(Document,'\',10)</P><P></P><P>This works for all the Documents with the following path:</P><P></P><P>\\hbeu.adroot.hsbc\dfsroot\gb002\corep_mi_qlikview\qlikview files\fermat\fermatqlikviewapp\</P><P></P><P>....but not the others. Is there a similar function I can use to extract the file name from right to left (instead of left to right) picking anything to the right of the "\" on the far right?</P></BODY></HTML> Mon, 29 Jul 2013 14:45:52 GMT https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535542#M200110 shane_spencer 2013-07-29T14:45:52Z Re: String Function similar to subfield https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535543#M200111 <HTML><HEAD></HEAD><BODY><P>how about something like:</P><P></P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">subfield</SPAN><SPAN style="font-size: 8pt;">(Document, '\', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">substringcount</SPAN><SPAN style="font-size: 8pt;">(Document, '\') + 1) </SPAN></P><P></P></BODY></HTML> Mon, 29 Jul 2013 15:07:59 GMT https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535543#M200111 mphekin12 2013-07-29T15:07:59Z Re: String Function similar to subfield https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535544#M200112 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: 'courier new', courier; background-color: #ffffff; font-size: 12pt;">=subfield(Document,'\',<STRONG>-1</STRONG>)</SPAN></P><P></P><P>The negative value counts from the right. </P><P><SPAN style="color: #737373; font-family: 'courier new', courier; background-color: #ffffff;">-Rob<BR /></SPAN></P></BODY></HTML> Mon, 29 Jul 2013 16:58:15 GMT https://community.qlik.com/t5/QlikView/String-Function-similar-to-subfield/m-p/535544#M200112 rwunderlich 2013-07-29T16:58:15Z