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].
3 posts
Page 1 of 1
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 Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
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
3 posts
Page 1 of 1