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

Help Studio
1

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

image
image814×231 10.5 KB

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

image
image710×147 3.22 KB

This is the data in the Excel file

image
image760×192 5.09 KB

2

@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.