Remove everything before 3rd instance of a character

[dawgfather]

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 · Accepted solution]

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

[rwunderlich]

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

-Rob

[dawgfather]

Worked like a charm...thank you!