Trim string before third instance of a character

[dawgfather]

I have a field that has a sometimes long and varied string - folder names in systems essentially.

I need to extract the last portion of the strings which happens to occur after the third instance of a forward slash ( / ).

Is there an easy method to count to the Nth instance of a character and then either trim everything before that, or keep everything after that - whichever way you want to think about it?

Sample data:

Given:

/vol/volume1/subvolume1

/vol/volume2/subvol23

/vol/volumeABCDE/filenameX

/vol/stringofcharacters/datafield

Wanted:

subvolume1

subvol23

filenameX

datafield

[vishsaggi · Accepted solution]

Try this?

LOAD *,

     Subfield(Given, '/', 4) AS GivenField INLINE [

Given

/vol/volume1/subvolume1

/vol/volume2/subvol23

/vol/volumeABCDE/filenameX

/vol/stringofcharacters/datafield

];