to find specifc text/wor in filename and text string and bring back the specifc text/word

Hi all,

I need some help in trying to find specific text and words in a textstring which could be in two different columns and to bring back the word in a column in the same row?

For example in one row i would like it to bring back "VGE" from column Filename2 and for the next example to bring back "dch_gdsp_t" in column Filename2?

But the text and words I am looking for could be these plus more.

This is a function I have to do every day so the forumula would be a great help and time for me to do some other work ;-)

Also, there are not always symbols such as _ etc in the filename.

I really hope that somebody can help ;-)