How to get out of "Title" 1 part of "Author"

[crnirg]

Now :
Author : Unknown
Title : Isaac Asimov@Pebble in the Sky

It should be like this :
Author : Isaac Asimov
Title : Pebble in the Sky


How to get out of "Title" 1 part of "Author"
Specifically, I mistakenly put a book into the title, which now looks to me in the title: Author@Title (@ me used to separate) and I would like to transfer the Author to its place now from the Title and to stay the rest in the Title as it should?
English is not the best for me.

[Sirtel]

Um... copy/paste? Or do you mean in bulk for several books?

[crnirg]

Sure for bulk . 350 books.

[theducks]

Bulk mode in the Metadata editor: Search and replace
Assumes all are like this: Title : Isaac Asimov@Pebble in the Sky
Not tested REGEX MODE use the right side to see all is good

2 Passes. The first copies the Author to its proper place

Search Title:

(.+?)\@(.+)

Destination field AUTHOR:
Replace with: \1

The 2nd cleans up
Same search
Destination field: Title
Replace with: \2

[crnirg]

What to say except many thank you - it works right!
If you could only briefly explain a little

Code:

(.+?) \@(.+)

Replace with: \1 or 2


Yes I don't have to read everything about Regex

[theducks]

Originally Posted by crnirg

What to say except many thank you - it works right!
If you could only briefly explain a little

Code:

(.+?) \@(.+)

Replace with: \1 or 2


Yes I don't have to read everything about Regex

The ( ) are the captures 1 and 2
.+ is a general wildcard. the ? makes it less greedy

\@ is just the escaped @ (escape eliminates any other meaning)
So Capture pattern #1 matches up to the @ and stops
Capture 2 is all the rest

the \# is what was captured. so you designate which goes where and in the case of part 2, get tossed because you replaced Title with just #2

[crnirg]

Thank you very much.
Given that the best way to learn is through examples, I will probably remember this (and write it down).

[theducks]

Originally Posted by crnirg

Thank you very much.
Given that the best way to learn is through examples, I will probably remember this (and write it down).

Search MR. There are a couple of excellent REGEX tutorials.
What we need can usually be done with simple REGEX.
Also We use the PCRE flavor

[Karellen]

Try this beginners tutorial. Its where I started a couple of years ago...
https://regexone.com/lesson/introduction_abcs

[crnirg]

Thank you both for the answers, really.

[crnirg]

When start
How merge 2 strings to 1 string - like :
Isaac Asimov Pebble Sky.pdf (strings #1 #2 #3 #4)
to
Author : Isaac Asimov (string #1 + #2)
Title : Pebble in the Sky (string #3 + #4)

Don't have separator .

[theducks]

ASSUMES Authors ONLY have 2 parts. Be sure to use on only those

(.+\s.+?)\s(.+)

Author is \1
Title is \2

No need to treat as 4 parts
\1=Anything space anything
\2=Everything else

If it has a Mi (but full name)
(.+\s*.\.\w\s+?)\s(.+)
the first \s allows for no space

[crnirg]

S field -- > Title
Search : (.+\s.+?)\s(.+)
R with --> \1
TEST:
Isaac Asimov Pebble Sky.pdf ---> Isaac Asimov Pebble

S field -- > Title
Search : (.+\s.+?)\s(.+)
R with --> \2
TEST:
Isaac Asimov Pebble Sky.pdf ---> Sky.pdf

[theducks]

Makes me think the that is not a space in the authors name
Try this for the first capture
(\w\s\w)

Also make sure Case Sensitive is not ticked

[crnirg]

Test:
Isaac Asimov Steel ---> result is ok :
(\1)
Author : Isaac Asimov
(\2)
Title : Steel

but Isaac Asimov Steel of Iron is not OK
( \1)
Author : Isaac Asimov Steel of
(\2)
Title : Iron