Simply switch firstname lastname on file name

Post any Bulk Rename Utility support requirements here. Open to all registered users.

Simply switch firstname lastname on file name

Postby Richard » Wed Apr 16, 2014 4:57 am

Hi All,

Thanks in advance for this tool, it looks fantastic and i'm certain it performs the required task, I just don't know the right configuration to make it happen.

So here I have a bunch of individual files that have been created with firstname followed by lastname however I have been asked to submit them all as surname followed by firstname. Here's a screen grab to make it easier:

https://www.dropbox.com/s/pjyin6zw0j4dr4l/names.png?m=

So it's simply a .docx document With this structure:

John Doe.docx

we would like them to be all changed to:

Doe, John.docx

Is this possible with your software? I tried having a play and also scanning / searching the forums but my search terms were rejected.
All names are of different lengths and some are also abbreviated, for example : John Doe-Harris
Only a small amount are abbreviated so I would be happy to fix those manually if the software can't handle that change.

Thank you kindly in advance
Richard.
Richard
 
Posts: 2
Joined: Wed Apr 16, 2014 4:47 am

Re: Simply switch firstname lastname on file name

Postby Stefan » Wed Apr 16, 2014 6:42 am

Covered several times in the forum, e.g. as 'swap'. Just browse and read the topics, or search with g00gle.
Stefan
 
Posts: 736
Joined: Fri Mar 11, 2005 7:46 pm
Location: Germany, EU

Re: Simply switch firstname lastname on file name

Postby Richard » Thu Apr 17, 2014 4:55 am

Thanks but as I said before I searched before putting up this thread

I searched again using the term swap withinthe 'bulkrenameutility.co.uk' domain and there were plenty of hits but none that gave a specific answer to my request. All were more advanced and using their sequences doesn't work on my text.
Richard
 
Posts: 2
Joined: Wed Apr 16, 2014 4:47 am

swap reorder change switch firstname lastname

Postby Stefan » Thu Apr 17, 2014 8:57 pm

FROM:
John Doe.docx
TO:
Doe, John.docx

Rule:
Match everything till space, then the rest.: ".+ .+"
Store both into backreference groups (...) for reorder: "(.+) (.+)"
Replace with second match first, add comma and space at your own, then add first match: \2, \1

DO:
RegEx(1)
Match: "(.+) (.+)"
Repla: "\2, \1"

Note: the " " quotes are only for clarify, don't write them too.
Stefan
 
Posts: 736
Joined: Fri Mar 11, 2005 7:46 pm
Location: Germany, EU


Return to BRU Support