How to display a list that matches the list?

Hello everyone,

I am having trouble what function to use.

What I am trying to achieve is I have a file name that says NEW_210917. I also have a list NEW_TXT_210917, RNW_TXT_TXT_210917, RPL_TXT_210917 and NEW_TXT_TXT_210917.

Regardless of the file names on the list. I need to return the list that has NEW and 210917 on their names.

So based on the given above. My result should be NEW_TXT_210917 and NEW_TXT_TXT_210917.

Any help will be appreciated. Thank you.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data