topic Re: Remove everything before 3rd instance of a character in QlikView

Remove everything before 3rd instance of a character

dawgfather — Wed, 25 Nov 2020 16:16:04 GMT

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 "\".

Example:

\\share1\test\folder

\\share.sharename.com\item\subfolder\somethingelse

\\server.us.domain.com\unanswered\question\please\help

...should yield:

test\folder

item\subfolder\somethingelse

unanswered\question\please\help

tincholiver — Mon, 04 Feb 2019 00:48:48 GMT

Replace(Campo,('\\'&SubField(Campo,'\',3)&'\'),'')

rwunderlich — Mon, 04 Feb 2019 01:16:19 GMT

=mid(Campo, index(Campo, '\',3) + 1)

-Rob

dawgfather — Mon, 04 Feb 2019 15:45:50 GMT

Worked like a charm...thank you!