topic Re: substring in QlikView https://community.qlik.com/t5/QlikView/substring/m-p/1364870#M830146 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use SubField() function:</P><P></P><P>SubField('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">\\kcpl1234\M2_ABC_SHARE\QV_PROJECTS\K-folde\qlikview\10_QVD_generator\qvd_Generator_abcd.qvw', '\', -1) or </SPAN></P><P><SPAN style="font-size: 13.3333px;">SubField(&lt;field_name&gt;</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, '\', -1).</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P>Learn more about SubField() at: <A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubField.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubField.htm">SubField ‒ QlikView</A></P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 27 Jun 2017 11:01:45 GMT hector_munoz 2017-06-27T11:01:45Z substring https://community.qlik.com/t5/QlikView/substring/m-p/1364869#M830145 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I have text like below </P><P></P><P>\\kcpl1234\M2_ABC_SHARE\QV_PROJECTS\K-folde\qlikview\10_QVD_generator\qvd_Generator_abcd.qvw </P><P></P><P>based on above text i want only qvd_Generator_abcd.qvw how to get it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/substring/m-p/1364869#M830145 prabhas277 2020-11-25T16:16:04Z Re: substring https://community.qlik.com/t5/QlikView/substring/m-p/1364870#M830146 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use SubField() function:</P><P></P><P>SubField('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">\\kcpl1234\M2_ABC_SHARE\QV_PROJECTS\K-folde\qlikview\10_QVD_generator\qvd_Generator_abcd.qvw', '\', -1) or </SPAN></P><P><SPAN style="font-size: 13.3333px;">SubField(&lt;field_name&gt;</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, '\', -1).</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P>Learn more about SubField() at: <A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubField.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubField.htm">SubField ‒ QlikView</A></P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 27 Jun 2017 11:01:45 GMT https://community.qlik.com/t5/QlikView/substring/m-p/1364870#M830146 hector_munoz 2017-06-27T11:01:45Z