Reversing artist and title within one specific field?

Post any Bulk Rename Utility support requirements here. Open to all registered users.

Reversing artist and title within one specific field?

Postby colmalk » Sun Jan 05, 2020 12:32 pm

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?
colmalk
 
Posts: 5
Joined: Sat Jan 04, 2020 1:05 pm

Re: Reversing artist and title within one specific field?

Postby therube » Sun Jan 05, 2020 1:28 pm

See what starting with this does, viewtopic.php?f=4&t=4676 ?
therube
 
Posts: 928
Joined: Mon Jan 18, 2016 6:23 pm

Re: Reversing artist and title within one specific field?

Postby colmalk » Sun Jan 05, 2020 5:38 pm

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?
colmalk
 
Posts: 5
Joined: Sat Jan 04, 2020 1:05 pm

Re: Reversing artist and title within one specific field?

Postby colmalk » Wed Jan 08, 2020 12:07 am

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??
colmalk
 
Posts: 5
Joined: Sat Jan 04, 2020 1:05 pm

Re: Reversing artist and title within one specific field?

Postby therube » Thu Jan 09, 2020 2:01 am

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.
therube
 
Posts: 928
Joined: Mon Jan 18, 2016 6:23 pm

Re: Reversing artist and title within one specific field?

Postby colmalk » Sat Jan 11, 2020 1:47 pm

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
colmalk
 
Posts: 5
Joined: Sat Jan 04, 2020 1:05 pm


Return to BRU Support