I have chunks of data in a notepad(.txt) which is seperated by comma but the catch here is it doesnt start from the very first line and every chunk of data must be read to import only second half of each line to corresponding header in the excel sheet.
FOR example: This is the type of data in notepad having date,time. So only time must be extracted and copied to cell (excel file) which corresponds to specific date(2020/11/16) and header(RunbookBCompletion) present in the notepad.
Date,RunbookBCompletionTime
20201116,05:44 AM
20201117,05:47 AM
20201118,05:39 AM
20201119,06:10 AM
20201120,05:49 AM
20201121,07:13 AM
20201122,06:01 AM
Like wise all the data must read and copy in the same manner. This report is ran once in every week so the excel should update the all the values from previous week till monday through data in notepad.
Is it possible?