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 ;-)

Hi

What is the full list of strings you want to search?
Why have you only brought back some of the items that match the string?

rylo

Hi rylo,
Thank you for replying.
For the moment those are the 4 examples I need to show in this file. But this is a file thathat I Recieve daily?
So it would be those texts in a many rows.sorry if I am unclear.

Thanks for your time.