Cut a sequence with an - separating both sides of it

Support
1

Hello
I have a problem. I made a mistake. I have in my TITLE and ARTIST column the same informations.
For ex. The Beatles - Let it be. of course not always Beatles songs.
How could I cut the sequence in order to keep only "The Beatles" in my artist column and "Let it be" in my Title column. All "ARTIST - TITLE" are separated with a "-"
Thanks

2

Use an action of the type "Guess value"
Source string: %title%
Target format string: %artist% - %title%

3

Thanks for this prompt answer
Yes I understand and know this
But what i wish is
In the ARTIST COLUMN : Cut everything after ARTIST that means Cut - TITLE for example The Beatles - Let it be I wish to cut "-Let it be" in order that remains only "The Beatles"
IN THE ARTIST COLUMN : Cut everything before TITLE that means CUT ARTIST - for example The Rolling stones - Angie I want to cut "The Rolling Stones-" in order that only remains "Angie"

4

I doubt that you have tried it.
Because:
As you say currently:
TITLE: The Beatles - Let it be
ARTIST: The Beatles - Let it be.

As both fields are the same, it does not matter which one to use as source.
If you take the contents of TITLE with "The Beatles - Let it be" and use
%artist% - %title% then you put
"The Beatles" into ARTIST (and overwrite the existing contents)
leave out the " - " and put
"Let it be" into TITLE (and overwrite the existig contents).

If it does not work, show us a real example preferably with a screenshot.

5

Thanks
OH YES BUT....
My field Artist is... empty !!

image
image1366×768 85.3 KB

I don't kown if you can see a part of the screen.

I need a routine in the Artist column saying : "Cut Everything before the - Title"
and in the column Title " Cut everything after the ARTIST. -

6

and then

Not an easy starting point.

If you would try it as suggested by @ohrenkino
image
you would see that this works perfectly and fill the Artist part from your TITLE to ARTIST and the Title part from TITLE only remains in TITLE.

7

Oh yes. As the Artist file is empty there will be nothing imported. Great !
Thanks from Nancy France !!
Alain

8

What?
There is no instruction anywhere in the action to import something from ARTIST. The source is the string in TITLE and that gets distributed to ARTIST and TITLE.

9

Whaoo...
I don't know HOW :rofl:it works but... It clearly works !!
Thanks again , always from NANCY FRANCE.
I'm a bit old you know : 78 :joy:

10

What exactly do you not understand?
Source format: %TITLE%
This means:
Use the content of the current TITLE

Guessing pattern: %ARTIST% - %TITLE%
This means:
Split the content in TITLE at the space minus space and write the leading part into ARTIST and overwrite the existing content in TITLE with the trailing part after the space minus space.

11

OK :cold_face: Thanks however. I discovered a naw fonction of this wonderful program.