Archiving Files - Creating New Folders and Moving Files

Hi,

Im wondering if anyone can help.

I have a shared server that a large number of XML files are sent to on a daily basis. I run a process at the end of each day to summarise these files, however, as part of this process I would also like to archive them based on their date.

The server path is I:\Messages\

The filename is made up of the below:

I have highlighted the date part in red. The remainder of the filename to the right of the red is a timestamp and then counter.

Brian_Example_20110516155242_000024

What I would like to do is archive these files based on Year and then Month.

So for example the above file would have the folder 2011 created if it does not already exist and then create the folder 05 - May if that does not already exist. The file would then be moved to this folder.

So the final filepath would become:

I:\2011\05 - May\Brian_Example_20110516155242_000024.xml

Year folders made up in format YYYY and Month Folders made up of the month number "-" and Month Name. 05 - May for this month.

Thanks in advance.

McC

Hi,

Thanks for your response. Much appreciated.

All of these are XML files.

There can be a great number of files that need archived at any one time so needs to be a quick looped process without actually opening the files.

I do not like the idea of having to create the directories etc as this should be an automated process and adds no benefit as would be quicker just copying the files over manually.

Does anyone else have any suggestions?

Thanks

McC