Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dawgfather
Creator
Creator

Remove everything before 3rd character

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\subfolder

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

\\www.qlikview.com\unansweredquestion\noidea\needhelp

 

...should yield:

test\folder\subfolder

item\subfolder\somethingelse

unansweredquestion\noidea\needhelp

1 Reply
Vegar
MVP
MVP

This is a repeated question similar to https://community.qlik.com/t5/New-to-QlikView/Remove-everything-before-3rd-instance-of-a-character/m...

But you are probably looking for
= mid( Campo, 1 + index( Campo, '\', 3))