Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Chico]

You have an option in the library tools/clean file properties, Move Articles to End where The first word is move to the end with a comma inserted.  Any chance a tool can be generated that does the opposite?  I have over 3000 files with the first name last (ie. Jovi, Bon).  Is there a tool or can one be made to undo this?  Just something that moves the first word after the comma to the front, add a space and remove the comma.

[gappie]

you could use an expression to do this. with expressions , better make a backup first and try with one file only.


now in the tag window , or with F2 in details put this in the artist tag

Code: [Select]

=Clean(listitem([artist],1,/,) listitem([artist],0,/,))
does it work, also check if there are no artists names where there are two ",".

 
gab

[phalanthus]

wouldn't find and replace be simpler ?- find "bloggs fred" and replace with "fred bloggs ? "

[fitbrit]

wouldn't find and replace be simpler ?- find "bloggs fred" and replace with "fred bloggs ? "

I don't think Bon Jovi released 3000 songs, I'm guessing there are tens if not hundreds of Fred Bloggses with different names.

[Chico]

wouldn't find and replace be simpler ?- find "bloggs fred" and replace with "fred bloggs ? "

That would work if they were all the same artist as fitbrit eluded to.
I did a search of artists name containing a "," and found over 5000 with a comma.  However, as gappie mentioned, watch out for artists names like Crosby, Stills, Nash and Young, where commas are needed.  After weeding these types of names, I've over 3000 with the first name last.
I'll try gappies idea!  If it can be done with out much coding, it would be a nice feature to have in the basic program.
Thanks for the replies!

[Chico]

Code: [Select]

=Clean(listitem([artist],1,/,) listitem([artist],0,/,))

Gab,
That worked perfectly!  I was able to rearrange all 3000+ artist ID Tags in well under an hour!    ThanX!

Now, can you please explain how that code in the artist field worked?  How does changing ([artist],1,/,) to ([artist],0,/,) move the name after the comma to the front and remove the comma? 

Thanks,
Chico

[gappie]

Gab,
That worked perfectly!  I was able to rearrange all 3000+ artist ID Tags in well under an hour!    ThanX!

Now, can you please explain how that code in the artist field worked?  How does changing ([artist],1,/,) to ([artist],0,/,) move the name after the comma to the front and remove the comma? 

Thanks,
Chico

great that it worked.
 
are you familiar with the wiki for the expressions? http://wiki.jrmediacenter.com/index.php/Media_Center_expression_language

as you can see i use the listitem expression two times, in the wiki it says:

ListItem(...): Use to return a value from a delimited list
List: List
Index: Index (starts at 0)
Delimiter: Delimiter (optional -- defaults to semi-colon)

in the "jovi, bon" case i use the "," as the delimiter. since the "," is also a sign used by the expressions it self i have to put a / in front of it, so it is recognized as a delimiter ( in this case).
so you can read this: listitem([artist],1,/,) listitem([artist],0,/,) as
from the with , delimited list return the second value put a space and return the first value.
the comma is not returned and i use the clean to get the spaces at the start away.

hope that this explenation is clear?

together with an if statement and the IsEqual and ListCount expression it should be possible to make an expression that would only change the order of the names with only one comma
 
gab

[Chico]

Thanks Gab!
I'll have to read up on the expression language.