I am Having Multiple file files in a single folder:
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
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