Script to move files based on file name to folder with same name

[dkriese]

I have 1000 files/documents saved with last and first names, I need to move these files/documents to their respective folders that also have last name first name. I would like the script to read the last name and move it to the folder with the same last name, some sort of script or batch file would do.

 

[strongm]

What have you tried so far?

 

[dkriese]

All I have done so far is to search the internet for a solution, tried robocopy, didnt have what I need. I did move all the documents to the base directory named client dat, where there are subfolders for each client name and the documents are also named by client name. each folder and document has two names with a space inbetween, I need the script to read the first part of the file name match it to the folder and move the document into that folder. I used a utility to remove commas from the file name, that worked ok. I had a script to do this a long time ago and can't find it, as I never had use for it until now.