I’ve extracted this data from a web browser via Data Scraping and would like to select the:
first instance of the filename containing “.NAI”
first instance of the filename containing “.NBU”
first instance of the filename containing “.CX1”
I’ve limited the MaxNumberofResults to 10, as sometimes there can be additional daily files but there will always be 1 or more rows with the above filename extensions.
What is the best way to do this? I tried the ‘For each’ but that selected each item containing those extensions (.NAI, .NBU, .CX1).
Appreciate you reply pattyricarte
However I think I may not be properly explaining my problem.
I want to click and download three files.
The first listed file that ends in .NBU
The first listed file that ends in .NAI
The first listed file that ends in .CX1
As there are many files ending in these extensions, but I only want to click and download the very first instance of these extensions.
Is there a way to identify the first match?
From the link you sent me, I can see that it is manipulating the string but I am interested in only identifying the first match. Am I mis-intepreting the link you shared?