substring after the last forward slash

[ymcmb]

Happy Thanksgiving everyone.

I'm looking for a way to find the substring for the text after the last forward slash and also the text in between the last 2 forward slash.

example - lib://CONTENT/SALES/NORTHEAST/MARKETING/document.docx

I'm looking to extract the text NORTHEAST and MARKETING and have those values placed in a separate table. Any clues?

Thank you.

[Or · Accepted solution]

In your example, the text after the last forward slash would be document.docx, wouldn't it?

In any case, this sounds like something you could do fairly easily with Subfield() and a negative field_no, as described here:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

e.g. Subfield(example,'/',-1)