I inherited a repository with a poorly designed structure. I'm trying to do some cleanup and reorganization in a repository that already contains hundreds of thousands of folders and documents.
I would like to search to return any documents that exist so that I can move them to their final destination. The current folder structure looks like this STUDENTS > FILE ROOM > STUDENTS. From there, the folders should proceed down by school year, like this...
But someone made a mistake years ago and now I'm trying to clean it up. They had a form that filed in the repository. They intended it to be named using the convention LastName, FirstName Identifier#. But they left off the LastName and FirstName. So they all filed with a comma followed by a space and then the identifier #. Under each of those folders is a folder called Registrar. So they look like this...
There are almost two thousand of those...too many to go through by hand.
I'm having no success at creating a search syntax to retrieve any documents from the Registrar folders. I feel like I need to use some type of wildcard for the misnamed folders but I can't get it to work. Can someone help me figure out the search syntax to retrieve any documents remaining at the Registrar level without including any documents from the folders named using school years?