Extract desired string part from awkward string using awk with advanced and hardcore approach?

Here is a string in which I would like to extract the file name part from it, but I’m not capable of it. So please help me.