Peters Flexible RenAmiNg Kit (PFrank) Forum Index Peters Flexible RenAmiNg Kit (PFrank)
Support and Discussion Site for the PFrank File/Folder Renaming Tool (***NEW HOME PAGE*** "http://pfrank.atwebpages.com")
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Renaming mixed named files

 
Post new topic   Reply to topic    Peters Flexible RenAmiNg Kit (PFrank) Forum Index -> Plugins
View previous topic :: View next topic  
Author Message
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Fri Jun 22, 2007 6:56 am    Post subject: Renaming mixed named files Reply with quote

Boy am I glad I found you! I've been working on this, one file at a time, for months!

I've got a lot of files that I need to change. From the following examples, you can hopefully see what I'm trying to accomplish. Here are some of the original file names followed by how I need them changed.

dw003-13 - coe, david allan - jimmy buffett don't live in key west.mp3
David Allan Coe - Jimmy Buffett Don't Live In Key West.mp3

eri83028-65 - Williams jr., Hank-a Country song.mp3
Hank Williams Jr. - A Country Song.mp3

re4-09 - Pet Shop Boys, The - West End Girls.mp3
Pet Shop Boys - West End Girls.mp3

sq30005-07 - Carey, Mariah & Snoop Doggy Dog - Crybaby.mp3
Mariah Carey & Snoop Doggy Dog - Crybaby.mp3

uS30051-06 - Johnson, Jack - Sitting, Waiting, Wishing.mp3
Jack Johnson - Sitting, Waiting, Wishing.mp3

te29189-10 - Seger, Bob and the Silver Bullet Band - This AIn't a song.mp3
Bob Seger And The Silver Bullet Band - This Ain't A Song.mp3

YXQW060107 - Foxx,Jamie West, Kayne - Extravaganza.zip
Jamie Foxx Kayne West - Extravaganza.zip

WQX0601-11 - Strokes, The - Juicebox.mp3
Strokes - Juicebox.mp3

TT6001-04 - Gaye, Marvin & Tammi Terrell - Ain't No Mountain High Enough.mp3
Marvin Gaye & Tammi Terrell - Ain't No Mountain High Enough.mp3

Also, I'll need a separate procedure to swap title and artist for some of the files.

If - bread.mp3
Bread - If.mp3

I'm probably the dumbest person ever to post here so please be as specific as possible with your reply.

Thanks in advance for your time...and please let me know how much money.
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Fri Jun 22, 2007 7:27 am    Post subject: Reply with quote

Give this a try:

Insert the following into the custom renaming list:

Row: 1
Search: '.*?[-]+.*?[ ]+[-][ ]+(.*?),[ ]*(.*?)[ ](.*)'
Replace: '\2 \1 \3'

Press scan and a preview list should come up. If you like what you see, press rename.
I noticed a minor problem with '&' turning into '&&'. If you don't have too many of those you can edit them manually on the preview list.
I'll have a look at what's wrong tomorrow.

For swapping title and artist use:

Row: 1
Search: '(?E)(.*?)[ ]*[-][ ]*(.*)'
Replace: '\2 - \1'

Hope that helps.
If you have any other questions, then please let me know.

For the donation amount, you can decide what it's worth to you.

Cheers,

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Fri Jun 22, 2007 8:40 am    Post subject: Reply with quote

Wow! That's amazing!

The only problem I see is I need to get "The" removed from the artist.

re4-09 - Pet Shop Boys, The - West End Girls.mp3
Pet Shop Boys - West End Girls.mp3

et38890 - Fray, The - The song.mp3
Fray - The Song.mp3

And I need all words capitalize.

Thank you very much...and how do I feed the kitty?
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Fri Jun 22, 2007 1:28 pm    Post subject: Reply with quote

This should do the trick (Do not include the single quotes when cutting/pasting - but I think you must have figured this out before):

Row: 1
Search: '^.*?[ ]+[-][ ]+(.*?),[ ]*(.*?)[ ](.*)'
Replace: '\2 \1 \3'
Row: 2
Search: '^The '
Replace:
Row: 3
Search:
Replace: '*Title Case (Also Deletes Extra Whitespace) in*Prefix*'

Note that row 1 has changed from before.
Let me know if you need any other refinements.

In the past I've had donations ranging from $10 to $25.
Any amount in that range would be greatly appreciated but it's totally up to you. From comments I've had, people that donate base the amount on how much work the tool has saved them.

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Fri Jun 22, 2007 5:26 pm    Post subject: Reply with quote

That seems to only replace capitalized "The". "The" but not "the" and now some others (other than capitalized) arn't being changed like before.


These aren't being changed:

rt84930-26 - Heartland - I Lover Her First.mp3
eqw0638-15 - Taking back sunday - make sure.mp3

These arn being changed:

rt03992-85 - Beatles, The - help.mp3
rut943-23 - Barry, len - 1 2 3.mp3

It looks like the ones without commas are not being changed.



The problem using Title Case is that names like "McBride" become "Mcbride" and "L.O.V.E" becomes "L.o.v.e..
I need to have it so it just capitalizes the first letter in each work without changing the entire word.

And please tell me HOW to send you money!!
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Sat Jun 23, 2007 5:46 am    Post subject: Reply with quote

I tried the following on all your sample file names and most of them work now. There is still a problem with two types of names which i'll elaborate on later.
Please give this a try.

Row: 1
Search: '^.+?[ ]+[-][ ]+(.*)'
Replace: '\1'
Row: 2
Search: '[-]'
Replace: ' - '
Row: 3
Search: '(.+?),(.+?)[ ]+(.*)'
Replace: '\2 \1 \3'
Row: 4
Search:
Replace: '*Title Case (Also Deletes Extra Whitespace) in*Prefix*'
Row: 5
Search: '^The '
Replace:


Also, there is a feature to not change the case of certain words. This can for example be used to prevent 'McBride' from changing to 'Mcbride'.
To set this up go to the options window (from main window, choose 'View' from the top menu, then 'Options ...). Choose 'Change Case' on the left side of the window. Then on the right side, click the 'Enable All' button for the top panel corresponding to 'Use Force Case (all words) table'

Then back on the left side, Choose 'Force Case (All Words). On the right side you will see a list of words. These words are all protected from changing case. Delete the list (unless you want to keep some of the words) and insert your own like 'McBride'.
Set up your words before applying the scan.

I mentioned before that there might be a bug with & changing to &&. THis was a red herring. It was a minor display bug in the preview sample panel that I will fix.

There is, however, a bug with preserving the case of words with periods in them. I could not protect the word L.O.V.E. from being changed to L.o.v.e. I'll fix this too. In the mean-time, there is a workaround. In row 6 you could just search for 'L.o.v.e.' and replace with 'L.O.V.E.' The saem principle can be applied to similar words.

There were 2 names that I could not fix completely. They are:
1)
dw003-13 - coe, david allan - jimmy buffett don't live in key west.mp3
which becomes:
David Coe Allan - Jimmy Buffett Don't Live In Key West.mp3

The problem here is the middle name 'Allan'. If i switch it with David, then that messes up other names like 'Bob seger and the silver bullet band' which would become 'Bob and the silver bullet band seger'. IN one case you want to swap the first word after the comma and in the other you need to swap 2 word after the comma. There is no way to make both work at the same time. This name and other like it will have to be fixed up manually in the end. Or you could add append a search replace line to change "Coe Allan' to 'Allan Coe'

2)
YXQW060107 - Foxx,Jamie West, Kayne - Extravaganza.zip
which becomes
Jamie Foxx West, Kayne - Extravaganza.zip

The problem here is that there are 2 names both of which have their first and last names switched. The tool can only switch the first name without affecting other names. Again this type of name would have to be fixed manually or a new search/replace added for the name.

I wish I could do something more about these 2 cases but unfortunately it can't be done in a way that doesn't mess up what is likely to be alot of other names. Hopefully there aren't too many situations like the above 2.

If there are other types of names that don't change properly then let me know and i'll see if they can be accommodated in a general fashion.

Let me know if there is any issues with the above or anything else.

Thank you very much for your generous donation!

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Sun Jun 24, 2007 6:26 am    Post subject: Reply with quote

Good news. I found an expression that should take care of case 2:
Add the following search replace combo into row 6:

Row: 6
Search: '^([^ \-,()]+?)[ ]+([^ \-,()]+?)[ ]+([^ \-()]+?)[ ]*,[ ]*(.*?)[ -](.*)'
Replace: '\1 \2, \4 \3 \5'

I tried this last row on my music collection and it didn't mess up anything. If you think the last row causes problems in your collection, then remove it.

Also, an improvement to row 3 would be to prefix the search pattern with a '^'.
ie. change row 3 to:

Row: 3
Search: '^(.+?),(.+?)[ ]+(.*)'
Replace: '\2 \1 \3'

That should take care of everything but case 1. This one can't be resolved because there is no way of knowing whether to swap 1 or more words after the first comma. The comands I gave you will swap only the first word.

Also, I have made a beta version of PFrank that corrects the problem of not preserving the case of words like L.O.V.E. when using the Force case tables.
The beta can be found at:
http://www3.telus.net/pfrank/PFrankSetup1.991.exe

Hope that helps.

If there are any problems, please send me the before/after/desired name sets as you have been doing.

Cheers,

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Sun Jun 24, 2007 8:20 am    Post subject: Reply with quote

This is looking good!

Here's another case I need fixed.

Bette Midler - Rose, The.mp3
Bette Midler - The Rose.mp3

Mitch Miller - Yellow Rose of Texas, The.mp3
Mitch Miller - The Yellow Rose of Texas.mp3

I want to keep "the" but it needs to be at the beginning of the song title.

I'm sure there will me more. I'll add them as I find them.

Thank you very much for your quick reponses!
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Sun Jun 24, 2007 3:49 pm    Post subject: Reply with quote

Have you already changed any names or are you still previewing at this point? I'm assuming you are still previewing.

The reason I ask, is that the addition to the custom list that i'll give you won't work on names like:

Bette Midler - Rose, The.mp3

but will work on something like:

te29189-10 - Bette Midler - Rose, The.mp3

The additional row is:

Row: 7
Search: '(?x)^(.*?)[ ][-][ ](.*?),[ ]*The[.]mp3 # move trailing "The'" to start of title field'
Replace: '\1 - The \2.mp3'

Peter.


Last edited by admin on Mon Jun 25, 2007 4:29 am; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Sun Jun 24, 2007 7:47 pm    Post subject: Reply with quote

Nope. Haven't changed anything yet...still previewing.
Back to top
View user's profile Send private message Send e-mail
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Thu Jun 28, 2007 8:40 pm    Post subject: Reply with quote

Can this be done.

Remove all numbers after the first one to four letters and then put them (letters) after the title in parentheses or brackets.

examples:

AB000-10 - Artist -Title.mp3
Artist - Title (AB).mp3

ABC0000-10 - Artist - Tile (ABC).mp3
Artist - Title (ABC).mp3

ABCD099-10 - Artist - Title.mp3
ABCD099-10 - Artist - Title (ABCD).mp3

Thanks for your continued support
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Fri Jun 29, 2007 4:16 am    Post subject: Reply with quote

It certainly can be done!

I've modified the first line and added a line at the end to take care of this.
The accumulated result (with built-in comments this time) is:

Row: 1
Search: '(?x)^([A-Za-z]+)[0-9\-]+[ ]+[-][ ]+(.*)[.](...)$ # save code prefix at end'
Replace: '\2.\3(\1)'
Row: 2
Search: '(?x)[-] # add spacing for later parsing'
Replace: ' - '
Row: 3
Search: '(?x)^(.+?),(.+?)[ ]+(.*) # swap comma-sep pair at start of artist field'
Replace: '\2 \1 \3'
Row: 4
Search:
Replace: '*Title Case (Also Deletes Extra Whitespace) in*Prefix*'
Row: 5
Search: '(?x)^The #remove leading 'The''
Replace:
Row: 6
Search: '(?x)^([^ \-,()]+?)[ ]+([^ \-,()]+?)[ ]+([^ \-()]+?)[ ]*,[ ]*(.*?)[ -](.*) # swap next comma-sep pair at start'
Replace: '\1 \2, \4 \3 \5'
Row: 7
Search: '(?x)^(.*?)[ ][-][ ](.*?),[ ]*The[.]mp3 # move trailing "The" to start of title field'
Replace: '\1 - The \2.mp3'
Row: 8
Search: '(?x)^(.*)[.](...)(.*)$ # move code prefix to end of title'
Replace: '\1 \3.\2'


The part saved at the end of the title is referred to as the 'code prefix' in the comments.
The above example really shows off the power of regular expressions. I've tried it on all the examples you gave earlier and it seems to work.
If you like, you can see the effect of each line if you enable one at a time starting with row 1 and have a name pasted into the 'sample name' panel.

Let me know how it goes and if you have any more questions!

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Fri Jun 29, 2007 5:43 am    Post subject: Reply with quote

Anyway to get the "code prefix" in caps? And some of them are mixed case.

AbC0000-10 - Artist - Title.mp3
Artist-Title (ABC).mp3

abc12345 - 10 - Artist - Title.mp3
Artist-Title (ABC).mp3



I'm about ready to rock & roll!
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Fri Jun 29, 2007 5:57 am    Post subject: Reply with quote

Replace row 1 with the following:

Row: 1
Search: '(?x)^([A-Za-z]+)[0-9\-]+[ ]+[-][ ]+(.*)[.](...)$ # save code prefix at end'
Replace: '\2.\3zzz.(\1)'
Row: 2
Search:
Replace: '*Upper Case in*Extension*'
Row: 3
Search: '[.](...)zzz[.](.*)$'
Replace: '.\1\2'

You should end up with 10 rows.
The first row saves the code prefix into a dummy extension. The second row changes the extension to upper case, the third row removes the dummy characters portion of the extension.

That should do it.

Have you made a backup? Might be an idea before you rock 'n roll with such a large number of files. Sounds like the excitement will begin soon!

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Fri Jun 29, 2007 6:25 am    Post subject: Reply with quote

Oh yeah! Got to have backups.

This works great. Thanks again.
Back to top
View user's profile Send private message Send e-mail
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Fri Jun 29, 2007 7:41 am    Post subject: Reply with quote

Now the trailing "The" in the title Is not getting moved.

AB45434-10 - chubby checker - Twist, the.mp3
Chubby Checker - Twist, The (AB).mp3
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Fri Jun 29, 2007 12:17 pm    Post subject: Reply with quote

It works for me. Maybe there was a mixup when adding the 3 rows from the last posting. Below is the overall summary of the regex expressions. Try recopying. I added one line at the end because I noticed some lines have a leading blank if they were subject to word swaps in the artitst portions.

Row: 1
Search: '(?x)^([A-Za-z]+)[0-9\-]+[ ]+[-][ ]+(.*)[.](...)$ # save code prefix at end'
Replace: '\2.\3zzz.(\1)'
Row: 2
Search:
Replace: '*Upper Case in*Extension*'
Row: 3
Search: '[.](...)zzz[.](.*)$'
Replace: '.\1\2'
Row: 4
Search: '(?x)[-] # add spacing for later parsing'
Replace: ' - '
Row: 5
Search: '(?x)^(.+?),(.+?)[ ]+(.*) # swap comma-sep pair at start of artist field'
Replace: '\2 \1 \3'
Row: 6
Search:
Replace: '*Title Case (Also Deletes Extra Whitespace) in*Prefix*'
Row: 7
Search: '(?x)^The #remove leading 'The''
Replace:
Row: 8
Search: '(?x)^([^ \-,()]+?)[ ]+([^ \-,()]+?)[ ]+([^ \-()]+?)[ ]*,[ ]*(.*?)[ -](.*) # swap next comma-sep pair at start'
Replace: '\1 \2, \4 \3 \5'
Row: 9
Search: '(?x)^(.*?)[ ][-][ ](.*?),[ ]*The[.]mp3 # move trailing "The" to start of title field'
Replace: '\1 - The \2.mp3'
Row: 10
Search: '(?x)^(.*)[.](...)(.*)$ # move code prefix to end of title'
Replace: '\1 \3.\2'
Row: 11
Search:
Replace: '*Delete Leading Whitespace in*Prefix*'


Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Sat Jun 30, 2007 6:44 am    Post subject: Reply with quote

I Had a couple of the lines messed up. All is well now.

I'm rolling again...
Back to top
View user's profile Send private message Send e-mail
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Sat Jun 30, 2007 9:08 am    Post subject: Reply with quote

I've got a problem with Thelma Houston and other groups where the first three letter are "The"

"Houston, Thelma" becomes "lma Houston"

The group "Them" becomes "m"

The group "They Might Be Giants" becomes "y Might be Giants"

Another problem is with 10,000 Maniacs. They become "000 10 Maniacs"

It looks like in Pfrank that the Detailed Information (results of hitting the scan button) is in some kind of data base. Any way to save that? Maybe export it to Excel?
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Sat Jun 30, 2007 5:28 pm    Post subject: Reply with quote

The problem with the removal of 'The' prefixes and the swapping of comma separated numbers is resolved with the following update:

Row: 1
Search: '(?x)^([A-Za-z]+)[0-9\-]+[ ]+[-][ ]*(.*)[.](...)$ # save code prefix at end'
Replace: '\2.\3zzz.(\1)'
Row: 2
Search:
Replace: '*Upper Case in*Extension*'
Row: 3
Search: '[.](...)zzz[.](.*)$'
Replace: '.\1\2'
Row: 4
Search: '(?x)[-] # add spacing for later parsing'
Replace: ' - '
Row: 5
Search: '(?x)^(\D.+?),(.+?)[ ]+(.*) # swap comma-sep pair at start of artist field'
Replace: '\2 \1 \3'
Row: 6
Search: '(?x) # don't swap comma-sep numbers in above'
Replace:
Row: 7
Search:
Replace: '*Title Case (Also Deletes Extra Whitespace) in*Prefix*'
Row: 8
Search: '(?x)^The[ ]+ #remove leading 'The ''
Replace:
Row: 9
Search: '(?x)^([^ \-,()]+?)[ ]+([^ \-,()]+?)[ ]+([^ \-()]+?)[ ]*,[ ]*(.*?)[ -](.*) # swap next comma-sep pair at start'
Replace: '\1 \2, \4 \3 \5'
Row: 10
Search: '(?x)^(.*?)[ ][-][ ](.*?),[ ]*The[.]mp3 # move trailing "The" to start of title field'
Replace: '\1 - The \2.mp3'
Row: 11
Search: '(?x)^(.*)[.](...)(.*)$ # move code prefix to end of title'
Replace: '\1 \3.\2'
Row: 12
Search:
Replace: '*Delete Leading Whitespace in*Prefix*'


I've sent you an email on a beta feature that should allow you to copy all of the above and then paste it all at once into the custom list.

As for exporting, YES, this feature is already available. You can export the displayed custom list info to an excel file by pulling down the 'File' menu on the preview window and selecting 'Export List ot CSV ...'

Cheers,

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sidthesurf



Joined: 22 Jun 2007
Posts: 12
Location: Asheville, NC

PostPosted: Tue Jul 03, 2007 6:02 pm    Post subject: Reply with quote

...And I've got more. I'm seeing just about every possible combination.


If any of these fixes can't be included in the current configuaration, seperate ones might work and possibly work even better.

For example. The double comas mentioned earlier. A configuaration just for that one problem would limit the scan results to only songs with double comas and I could more easily see the ones that needed correcting.


Problem first.
Solution next.


Artist - Title - abc10230-10.mp3
Artist - Title (ABC).mp3

Artist - Title.mp3
Artist - Title (ABC).mp3
(this I know would have to be a seperate configuaration as I would need to be able to change the prefix variable)

abc1234-5 - artist - title, A.mp3
Artist - A Title (ABC).mp3

abc12345 - Artist - Title.mp3
Artist - Title (ABC).mp3

abc12345- Artist - Title.mp3
Artist - Title (ABC).mp3


Title - Artist (ABC).mp3
Artist -Title (ABC).mp3



Still having problems with numbers with comas.

abc12345-10 - Artist - 50,000 Something.mp3

Becomes:

000 Artist - 50 Something (ABC).mp3

Of course needs to be:

Artist - 50,000 Something (ABC).mp3
Back to top
View user's profile Send private message Send e-mail
admin
Site Admin


Joined: 09 Mar 2007
Posts: 448
Location: Canada

PostPosted: Wed Jul 04, 2007 4:22 am    Post subject: Reply with quote

Here is an update based on the new criteria:

Row: 1
Search: '(?x)^([A-Za-z]+)[0-9\-]+[ ]+[-]*[ ]*(.*)[.](...)$ # save leading id code (var1) at end'
Replace: '\2.\3zzz.(\1)'
Row: 2
Search: '(?x)^(.*?)[ ][-][ ]*([A-Za-z]+)[0-9\-]+[.](...)$ # save trailing id code at at end'
Replace: '\1.\3zzz.(\2)'
Row: 3
Search:
Replace: '*Upper Case in*Extension*'
Row: 4
Search: '(?x)[.](...)zzz[.](.*)$ # remove dummy extension'
Replace: '.\1\2'
Row: 5
Search: '(?x)[-] # add spacing for later parsing'
Replace: ' - '
Row: 6
Search: '(?x)^(\D.+?),(\D.+?)[ ]+(.*) # swap comma-sep pair at start of artist field'
Replace: '\2 \1 \3'
Row: 7
Search: '(?x) # don't swap comma-sep numbers in above'
Replace:
Row: 8
Search:
Replace: '*Title Case (Also Deletes Extra Whitespace) in*Prefix*'
Row: 9
Search: '(?x)^The[ ]+ #remove leading 'The ''
Replace:
Row: 10
Search: '(?x)^([^ \-,()]+?)[ ]+([^ \-,()]+?)[ ]+([^ \-()]+?)[ ]*,[ ]*(.*?)[ -](.*) # swap next comma-sep pair at start'
Replace: '\1 \2, \4 \3 \5'
Row: 11
Search: '(?x)^(.*?)[ ][-][ ](.*?),[ ]*The[.]mp3 # move trailing "The" to start of title field'
Replace: '\1 - The \2.mp3'
Row: 12
Search: '(?x)^(.*?)[ ][-][ ](.*?),[ ]*A[.]mp3 # move trailing "A" to start of title field'
Replace: '\1 - A \2.mp3'
Row: 13
Search: '(?x)^(.*)[.](...)(.*)$ # move saved id code to end of title'
Replace: '\1 \3.\2'
Row: 14
Search:
Replace: '*Delete Leading Whitespace in*Prefix*'


With PFrank 2.01, you can select & copy the above with your mouse and paste into the custom list using CTL-F2.

This takes care of everything except the following:

Artist - Title.mp3
Artist - Title (ABC).mp3
- Don't know where the ABC comes from


Title - Artist (ABC).mp3
Artist -Title (ABC).mp3
- if there are already 'Artist - Title (ABC).mp3 that exist, then you will need a separate custom list for this one.


If there are any more criteria, then email me a complete list and we can discuss further updates.

I've enjoyed coming up with this list since it really shows the power of PFrank. Some useful enhancements and a few bug fixes have also been developed as a result of the above; these are available in version 2.01.

Cheers,

Peter.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Peters Flexible RenAmiNg Kit (PFrank) Forum Index -> Plugins All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © phpBB Group. Hosted by phpBB.BizHat.com


Start Your Own Video Sharing Site

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!
For Support, visit Forums.BizHat.com