GoAnywhere Forum

We have a spreadsheet with Hundreds of rows. We would like to take a column from the spreadsheet, find the files containing a specific value in that column and list it out. Is that doable? We do not want to replace the values with the search and replace we just want to list the files containing that value.

Yes!

Do a readExcel task to generate a rowset
Loop through the rowset
for each row, read the desired column [1] is column 1, [2] is column 2, etc
then, so a search on that value.

It was the search I am not sure how to do the only search function I saw was a search and replace, is what I want to do is a search and write out the file name where the item was found.