Skirge01
Board Buff
Group: Members
Posts: 55
Joined: Aug. 2002 |
 |
Posted: Aug. 18 2002,00:10 |
 |
John,
You got me there! I didn't consider that issue. Two ideas come to mind:
1. This assumes you have no files with a leading space in any field you're working with AND that you don't have it set up like this:
Artist - Album - Title.mp3
If you have the spaces before and after the '-', you'll need to remove those first and put them back afterwards.
Now, to do this, you could use the substring replacements and make ' the ' or ' The ' (noting the leading and trailing spaces) all capitals. Then use the same function and replace 'The' (case sensitive) with a character (i.e. ? ! \ ^) you don't have in any of the fields you're working on. Run it again and put in whatever character you chose as the "Replace" and delete everything from the "With" (make sure there's not a blank space in there). Run it one last time and do a case fix on the "THE" you capitalized to make it what you would normally have it as.
2. If you know DOS, you could use the REN command with wildcards to strip the word out. Then just rename the fields according to the filenames. (If you don't have albums in your filenames this obviously won't solve that issue unless you put them in.) Use #1 if you aren't familiar with DOS.
You're doing something fairly complex, so it's not so easy. Although, it might be nice to have an option to look at only the first or last "word" in a field. I don't know how difficult that would be to program, though.
Let me know if this works out for you. Make sure you do a PREVIEW on each step!!! I certainly may have missed some condition that would cause an undesired result. I don't want to get yelled at if it doesn't work!  I always copy the files I'm going to be working with to another place, that way if I totally screw them up, I can go back to the originals. Undo is nice, but Windows sometimes crashes before you can undo (or in the middle of it).
George
p.s.
I'm wondering if there's a simpler way we're both overlooking???
|
