https://community.qlik.com/t5/QlikView/Remove-everything-before-3rd-character/m-p/1538889#M746675 This is a repeated question similar to <A href="https://community.qlik.com/t5/New-to-QlikView/Remove-everything-before-3rd-instance-of-a-character/m-p/1538850" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Remove-everything-before-3rd-instance-of-a-character/m-p/1538850</A><BR /><BR />But you are probably looking for<BR />= mid( Campo, 1 + index( Campo, '\', 3)) Mon, 04 Feb 2019 05:06:53 GMT Vegar 2019-02-04T05:06:53Z https://community.qlik.com/t5/QlikView/Remove-everything-before-3rd-character/m-p/1538832#M746674 <P>I have a data set that has a variety of data of any lengths. I am trying to trim off everything before (and including) the 3rd instance of a "\".</P><P>Example:</P><P>\\share1\test\folder\subfolder</P><P>\\share.sharename.com\item\subfolder\somethingelse</P><P>\\<A href="http://www.qlikview.com\unansweredquestion\noidea\needhelp" target="_blank">www.qlikview.com\unansweredquestion\noidea\needhelp</A></P><P>&nbsp;</P><P>...should yield:</P><P>test\folder\subfolder</P><P>item\subfolder\somethingelse</P><P>unansweredquestion\noidea\needhelp</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-everything-before-3rd-character/m-p/1538832#M746674 dawgfather 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Remove-everything-before-3rd-character/m-p/1538889#M746675 This is a repeated question similar to <A href="https://community.qlik.com/t5/New-to-QlikView/Remove-everything-before-3rd-instance-of-a-character/m-p/1538850" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Remove-everything-before-3rd-instance-of-a-character/m-p/1538850</A><BR /><BR />But you are probably looking for<BR />= mid( Campo, 1 + index( Campo, '\', 3)) Mon, 04 Feb 2019 05:06:53 GMT https://community.qlik.com/t5/QlikView/Remove-everything-before-3rd-character/m-p/1538889#M746675 Vegar 2019-02-04T05:06:53Z