How to identify error files and moving to seperate folder ?

[madhubabum]

Hi Experts

I am Having Multiple file files in a single folder:

SampleFiles:

                    EmpData,EmpData1,EmpData2,.......EmpData10.

Note : Some files are Having Header information,

          Some files Not having Header Information,

          Some fields are Missing,

          Some files  are not Having Data

Step1 :  How We can identify which file is having Errors

Step2 : Then move the error files into separate folder .

Step3 :  Move files , which are not having error files into another folder.

Please help to me write the script to identify the error files.

Please find attached files for testing.

Thanks in advance

Regards,

Madhu

[marcus_sommer]

You need to run through this folder with filelist, check your conditions (probably per if-loops) and move them per execute-statement. Here some examples:

Re: Pick the latest excel file from folders

Re: how to skip a Excel Workbook ?

EXECUTE command to MOVE shared files but DON'T Overwrite

- Marcus