topic Re: Trim string before third instance of a character in QlikView

Trim string before third instance of a character

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

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

Re: Trim string before third instance of a character

vishsaggi — Thu, 13 Apr 2017 21:29:41 GMT

Try this?

LOAD *,

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

Given

/vol/volume1/subvolume1

/vol/volume2/subvol23

/vol/volumeABCDE/filenameX

/vol/stringofcharacters/datafield

];