Extract Notepad specific Data to Excel

[raymondhui (Raymond)]

I would like to extract specific value from the notepad to a excel. I can extract first part of the data by using regular expression match, but I cant extract

Thanks

[raymondhui (Raymond)]

I tried to use regular expression regex match to extract the value from EXPIRED to REPORT but I cant do the same things on the second part. My logic is to generate the table first and then read all content into a variable and started to trim the value I want.

[Uthraa]

Hi,
Refer this thread

Fetching multiple strings from document

Hi Everyone, I have a word document in the below format [image] I am able to retrieve data. Now, i need to retrieve first row from original and new and perform some process. Then need to retrieve second row from original and new and perform some process. The bot should throw an exception if any third row of ids given either in original or new section. Could you please give an idea on this? Thanks, Ulaga

Thanks.

[raymondhui (Raymond)]

Hi would you like to explain further? Thanks