Hi guys and dolls,
First of all, amazing program! This has easily saved me about a month's worth of manual work, mainly because of the subfolder facility.
Anyway, I'm trying to do something very similar to the lastname, firstname swap but it's a little more complicated. I have files which are formatted in three different ways:
1) lastname, firstname - title - idcode
2) idcode - lastname, firstname, title
3) idcode - title - lastname, firstname
To make matters more complicated, sometimes there are more than one person in the name section or more a middle name as well: lastname, firstname middle name or lastname, firstname & firstname lastname etc etc
The RegEx code at the beginning of this thread works a treat in fixing the 1) example but doesn't obviously touch the other two. I've tried for the life of me to get my head around what the components of the code all mean and therefore how I can alter it to apply to 2) & 3) but I'm afraid it's beyond me.
Hopefully there's a few smart boffins in here that see it as easy as 1+1...