Page 1 of 1

How can you moving a part of titles?

PostPosted: Wed Jan 27, 2021 8:42 pm
by Sean McDonough
Hello - I have files that are titled like this:

smith, joe_123456_01-12-1988
williams, gregory_123457_01-11-1989


The problem is that the numbers inside of the _######_ need to be moved to the front so the titles are:

123456_smith, joe_01-12-1988
123457_williams, gregory_01-11-1989


How can this be done? I know how I could move the DOB to the front without a problem because all DOB's are 10 characters and are all at the end of the titles, so pretty straight forward. The problem here is that not all names have the same number of characters, but all of the ######'s are 6 characters, or 8 with the _######_. Is there a way to move them to the front?


Just so you know, I don't understand all of the codes, I only know the basic setup with the 14 different options and I know nothing about Javascript.

Thanks,
Sean

Re: How can you moving a part of titles?

PostPosted: Wed Jan 27, 2021 9:52 pm
by therube
1:RegEx, (enable) Simple

Code: Select all
Match:  %1_%2_%3
Replace:  %2_%1_%3

Deliminate on the underscores.
%1 = everything up to the first underscore (name)
%2 = everything up to the next underscore (number)
%3 = everything after that (date)
Then just rearrange their ordering, inserting wanted underscores (or whatever) where appropriate.