Sorting files into respective folders

[dejianguy]

Hi all,

I am writing a code to sort out 40-50 pdf files daily into a few respective folders. (Let's name these folders Alpha, Bravo and Charlie for now)

Each of these pdf files have a unique file name at the front and a date indicated at the back.

Some example of it is as follows:
DAS213D_20061012.pdf (This file needs to be at Alpha folder)
GFGSTER_20061012.pdf (This file needs to be at Bravo folder)
SAEAHTA_20061012.pdf (This file needs to be at Charlie folder)

Any tips from the pros?

[Kenneth Hobson]

Welcome to the forum!

I see no logic in your naming convention. Why would the first file go into the first folder? Is that what you want. by file name and folder name sort order? So for 50 files you want to put in 50 folders? Would the folders exist already?

[dejianguy]

Hi!

Thanks for replying and apologies for the ambiguity.

Yes. that is what i need. To move specific files into specific folders. And nope. There will be around 50 files but at the end of the day, they will all need to be placed in the 3 respective folders.

I have learnt to create the folders using MkDir.

The files are currently at C:\Users\Jaack\Desktop\Source
Some example of it is as follows:
DAS213D_20061012.pdf (This file needs to be at C:\Users\Jaack\Desktop\Destination\Alpha folder)
GFGSTER_20061012.pdf (This file needs to be at C:\Users\Jaack\Desktop\Destination\Bravo folder)
SAEAHTA_20061012.pdf (This file needs to be at C:\Users\Jaack\Desktop\Destination\Charlie folder)
ASFDSFH_20061012.pdf (This file needs to be at C:\Users\Jaack\Desktop\Destination\Alpha folder)
123GDAS_20061012.pdf (This file needs to be at C:\Users\Jaack\Desktop\Destination\Alpha folder)
SADFSER_20061012.pdf (This file needs to be at C:\Users\Jaack\Desktop\Destination\Charlie folder)

There are a total of 50 files similar to those above and needs to be sorted out.

[Kenneth Hobson]

I still don't see a correlation between filenames and folders.

If you have a naming convention or a list of prefix names that goes to each folder, that can be done. Some make a table for such things.

[dejianguy]

Hmm.
On the 1st day, the file is obtained as
DAS213D_20061012.pdf
On the next day, the file is obtained as
DAS213D_20061013.pdf

The date at the back of the file changes, but the first 7 letters of each file remains the same. Is this the correlation that you are referring to?

[scottiex]

No,
We want you to create a table that defines every possible start of the file name (or give us a precise rule that separates Alpha/bravo/charlie [and possibly "do nothing"] and never fails).

[Kenneth Hobson]

No.

Correlation means this versus that. This is the file name. That is the folder name. http://www.dictionary.com/browse/correlation?s=t

You have two parts to your file name. What part of the file name correlates or has a relationship to the folder name? Or, does the content in the file govern what folder it goes to? If that is the case, after the pdf creation, that becomes difficult unless you have Adobe Acrobat Pro.

IF you have a table of base file names in a column and matching folder names in the next column, paste it or attach the file. Click the Go Advanced button in lower right of a reply, and then click the Manage Hyperlinks below the reply box.

In post #3, you have them going to folders a,b,c,a,a,c. There is no logic that I can see for why you did that. The files are not even sorted in any manner obvious to me.

I can show you how to get the filenames and order by filename or date, and how to "move" them to another folder but without knowing the logic, I don't see what purpose it would serve. When you say sort, I guess you mean move.

If you don't care about correlation, it is easy to move the files to any set of folders and then loop the folders again if more files.

[dejianguy]

Thanks scottiex and kenneth for trying your best to help me.

Apologies for using the wrong jargon here and there.

There is no correlation or relationship between the file and the folder name at all. And thankfully, it is not the content in the file that i am looking for, it is just the file name of the pdf.


[QUOTE=Kenneth Hobson;4777026
When you say sort, I guess you mean move.

If you don't care about correlation, it is easy to move the files to any set of folders and then loop the folders again if more files.[/QUOTE]

Yup, this is what i need.

In really layman terms and a little bit of coding knowledge, this is what I have in mind.

If filename contains "DAS213D" or "ASFDSFH", move it to C:\Users\Jaack\Desktop\Destination\Alpha
else if filename contains "GFGSTER", move it to C:\Users\Jaack\Desktop\Destination\Bravo

Loop this until there are no more files left

[Kenneth Hobson]

Run this in mMain module, Sub rnFiles(). Always backup files before testing macros.