Hi,
I am trying to remove a chunk of a string after a third pattern match:
Here is an example:
Original string: /x-x-x-x/home1/home/M
trying to achieve: /x-x-x-x/home1
Basically I am trying to remove everything after the third occurrence of '/'...
Here is part of my first attempt..
when regexp_replace (filepath. '/',1) > 2
thenĀ regexp_replace(filepath, '/', '',1,3)
This just replaces one character... Is there away to wildcard and remove using regexp_replace?
Thanks for the help in advance.
-Abe