Search through excel files in folders then copy them to another folder

Help
1

Hello,

I want to search through excel files in a folder then copy them else where.

22
22562×775 17.7 KB

2

@sparkplug93

May I know what error are you getting here ?

3

Hi @sparkplug93

Please add [for each row] for get data in your datatable
and try to use follwing condition

string.Join(“,”,row.ItemArray).Contains(“NORTH”)

See as below for guideline

image
image565×622 15.6 KB

I hope it would be useful for you :blush:

4

I’m getting an error at output tables (variable type DataTable) and with the condition for the if statement. Additionally, is there a way to move these files to a folder if they contain the keyword?

Thanks

5

If you want to search anywhere in that excel THEN
Use
Read Range-----dt1
output datatable—textdt
if-------textdt.contains(“North”)
yes then Move/Copy

6

No objects are being moved but I’m not getting an error. Any ideas?

11
11600×750 18 KB

7

Will you pls share the values that are used in filename and copy??
if possible share your xaml

8

ExcelDocSearch.xaml (10.1 KB)

9

Hello
Do you want to check North keyword in entire excel ryt?
if yes then You can directly use LookUp Range so if that matches the keyword then
ExcelDocSearch.xaml (13.6 KB)

or if you want to search for each row then
ExcelDocSearch.xaml (10.4 KB)

10

Neither are working. But the first one worked much quicker.

11

Hope u get the idea make changes as per your need
Happy Automaion

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.