Need to rename Folders by swapping first and last names

Using Visual Studio 2008

I have 40,000 folders each with a employee name.
The way it was setup orignally was was "First Name Last Name" Like "Cindy Jones"

However some of the names include middle initials (in some cases multiple initials)  and "jrs"

Like "Brian W. H. Marks Jr"

I need to swap first and last name order for all the folders (rename them and add a comma)
I can do the simple names but I am having trouble with the middle initials and suffixes.

How can I swap:

Brian W. I. Marks Jr
Marks, Brian W. I.  (Jr is irrelevant)

Cindy A. Jones
Jones, Cindy

And recourse all the directories of a specified folder?

(Note: I do NOT need to rename any files or folders under the original subfolder listing of 40K folders.)
Who is Participating?
Jesus RodriguezConnect With a Mentor IT ManagerCommented:
Look at this code. I try with the two names and works find

        Dim FolderName As String
        Dim I, CDots, Lpos
        CDots = 0
        Lpos = 0
        FolderName = Me.TextBox1.Text
        Dim CSuffix(3)
        CSuffix(1) = "Jr"
        CSuffix(2) = "Mr"
        CSuffix(3) = "Mrs"
        For I = 1 To 3
            FolderName = Microsoft.VisualBasic.Strings.Replace(FolderName, CSuffix(I), "")
        Next I
        'Count the Dots in the string
        For I = 1 To Len(FolderName)
            If Mid(FolderName, I, 1) = "." Then
                CDots += 1
                Lpos = I
            End If
        Dim NewFolderName
        If Lpos > 0 Then
            NewFolderName = Microsoft.VisualBasic.Right(FolderName, Len(FolderName) - Lpos - 1) + "," + Mid(FolderName, 1, Lpos)
            'put the procedure for the regulars

        End If
        Me.label1.text = NewFolderName

Open in new window

You will need to create some rules for the renaming.
I would try detecting the presence of the full stop and use that as the basis.

You could either use regular expressions or the Split function. You could split on the "." and then split on the space, then that would split up all the sections.

If nobody else comments i'll have a go at the function for you later
EGormlyAuthor Commented:
I was splitting on the space and then trying to loop it to find other parts of the "first" name.

I ust can't seem to loop it properly, the strip is all fubar.
Patrick MatthewsConnect With a Mentor Commented:
EGormly,You may want to have a look at this article: is focused on VB6/VBA and not VB.Net, but the basic strategy of using RegExp may still be useful for you.Patrick
EGormlyAuthor Commented:
Thank to you both. The code example was great K-designers and matthewspatrick, that link was very informative!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.