Suggestion - open .txt file with random name, search for certain data and then rename the file

[MonicaJain (Monica)]

Hi,
I have bunch of files saved in Notepad and all of them have machine generated number.

I need to save them with specific names. An excel file has the combination and part of the data in excel is available in the .txt file.

First I need to save/rename in .txt.

Any suggestion how this can be achieved?

This is how .txt files are saved

Company Name is Available in .txt file that is also in Excel

This is the data in the Excel file

[SenzoD (Senzo Dlomo)]

@MonicaJain, how would we know what name to give the file?

does each file contain its name inside? i mean when you read the file would it have its unique name in the content.