Extract Notepad specific Data to Excel

excel
activities

#1

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 following value.


I have attached the excel file i want.

Thanks.Output.xlsx (8.7 KB)


#2

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.


#3

Hi,
Refer this thread

Thanks.


#4

Hi would you like to explain further? Thanks