Page 1 of 1

Reversing artist and title within one specific field?

PostPosted: Sun Jan 05, 2020 12:32 pm
by colmalk
Within my 'Name' field, often titles will appear as:
The Four Aces - Written On The Wind 
Wally Lewis - Kathleen

whereas I wish them to present with title firstly, as in
Written On The Wind - The Four Aces
Kathleen - Wally Lewis

Can anyone please guide me with a formula to apply (and where?), to achieve my preferred order within the 'Name' field?

Re: Reversing artist and title within one specific field?

PostPosted: Sun Jan 05, 2020 1:28 pm
by therube
See what starting with this does, viewtopic.php?f=4&t=4676 ?

Re: Reversing artist and title within one specific field?

PostPosted: Sun Jan 05, 2020 5:38 pm
by colmalk
Sorry, the rube, I don't really understand. Yes I did try that other question but it only got views, no response. As I said before, I did try the old suggestion but was 'greyed out'.
I also revamped my question because I hadn't made clear that my artist and title are within the same field
Do you have a suggestion please?

Re: Reversing artist and title within one specific field?

PostPosted: Wed Jan 08, 2020 12:07 am
by colmalk
Well, I still can't figure exactly what therube was suggesting ........ and why he doesn't seem inclined to clarify - or help me. I am new to the
programme and to the Forum, so a bit of understanding would be appreciated. I'm sure the experts on here can answer my question without too much trouble to them??

Re: Reversing artist and title within one specific field?

PostPosted: Thu Jan 09, 2020 2:01 am
by therube
viewtopic.php?f=3&t=3494&p=8841

Code: Select all
mozart - symphony no. 40 - 'movement 1'.mp3
   'movement 1' - mozart - symphony no. 40.mp3
24 Hours – Two Sides of Crime S01E04 - .mkv
    - 24 Hours – Two Sides of Crime S01E04.mkv
Adrevon, Jean-Pierre - Jerod si pisica.doc
   Jerod si pisica - Adrevon, Jean-Pierre.doc
Benford, Gregory - Poveste razboi.epub
   Poveste razboi - Benford, Gregory.epub
Benford, Gregory - Poveste de razboi.epub
   Poveste de razboi - Benford, Gregory.epub
Wally Lewis - Kathleen
   Kathleen - Wally Lewis
The Four Aces - Written On The Wind
   Written On The Wind - The Four Aces

Note the first two items, which have multiple -'s.

Re: Reversing artist and title within one specific field?

PostPosted: Sat Jan 11, 2020 1:47 pm
by colmalk
I've been awol for a few days, just looked at Forum again. This got I gottit! Many thanks for your clarification, it is much appreciated