How can I use information from a log file for a loop for each?

I am automating tasks with a software, this software has a log file that I have to wait for a positive or negative answer for the rest of the loop. The problem is that I can’t capture this response. There would be a way to transfer the data from the log file directly into an excel file. I can’t find the logic, if anyone could help me I would be very grateful. Thank you

Hi @Coelho_Smaylle

Welcome to forum

Can u show sample log file and resulting excel file u want as output

This is the log file https://drive.google.com/file/d/1xR5H6mukXZ_5ZgLAsdY8cm0VaiKmSOPz/view?usp=sharing
and this is i want
https://drive.google.com/file/d/1JuZbJzpCS_hez7Fl6U41tDaVnZJMBSWs/view?usp=sharing

Hi @Coelho_Smaylle

I saw ur xls file u need

is it the pattern u need in final?

yes actually I just need the values of the last column
Capture