find in files

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
3 posts Page 1 of 1

ehersh

Posts: 56
Joined: Mon Sep 26, 2016 12:50 pm

Post by ehersh » Tue Mar 14, 2017 8:17 am
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.

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Tue Mar 14, 2017 9:06 am
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.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696

ehersh

Posts: 56
Joined: Mon Sep 26, 2016 12:50 pm

Post by ehersh » Tue Mar 14, 2017 9:52 am
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.
3 posts Page 1 of 1