I am trying to read a number in a CSV file.
The number will always be directly to the right of the field saying “Lodgement”, but where that pair of text appears in the rows will differ every time I need to read this file. It could be 2 rows down, it could be 10 rows down, etc.
Essentially, I want to grab the “123456” below.
Any ideas on how I can read the CSV, search for the phrase “Lodgement” and then only grab the number directly to the right of it?