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].
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].
find in files
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 Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: find in files
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.
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Re: find in files
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.