Hi, In the artist field, when the artists name is in the form "lastname,firstname" , how do I.... -separate the two names/add a space -remove the comma and -swap the last and first names? Thank-you in advance if anyone can be of help.

tineg: Hi, In the artist field, when the artists name is in the form "lastname,firstname" , how do I.... -separate the two names/add a space -remove the comma and -swap the last and first names? Thank-you in advance if anyone can be of help. If you have a field: lastname,firstname or s…

Thanks DetlevD...I gave that a try first thing this morning before heading out to work this morning and I couldn't be happier. Thanks again.

Briliant! Was looking for This!! A+

Before I reinvent the wheel: Is there a known way to do something like the reverse, to change a field with, say, "John Coltrane" to "Coltrane, John" by swapping the words and placing a comma after the one moved to the first position? I do this a lot by hand (and realize that I would have to look at …

[image] josephzitt: Before I reinvent the wheel Yes, that wheel has been invented a long time ago, See the HowTos: [image] Regular Expressions Howto Another one, that switches first and last names (for instance, Jacques Brel will become Brel, Jacques): Regular Exp…

See also this discussion whether it really makes sense to swap at all: [image] First Name Last Name with any frailing words to Last Name, First Name and Trailing words Support Didn't you participate in a thread that deals more or less with the problem of lists with a slash…

Add space to, swap Lastname,Firstname

Support

ohrenkino May 25, 2024, 12:11pm 6

Yes, that wheel has been invented a long time ago,
See the HowTos: