I am building a robot that needs to scrape data from a webpage (it will be a table) and that table has two columns (called POnumber and POdate).
I want the robot to read each row, reading the POdate and if that POdate is yesterday, then copy the POnumber from that same row. For example:
(this is a copy from the notepad, where I printed my table just to see the two columns)
So, for this table, I want to read the first row, and ok, that is not yesterday, so nothing. The second row has yesterday’s date, so I want to copy the number 4701 from that same row. How could I do this, I have no idea?
After copying the number 4701, I want to find that number on a webpage and click on it, so I guess I need to save that number to a variable also?
Here is what I have come up with so far, but it is missing a lot (I am also not sure if the date will be in the right format if I use the code I currently have there):