Title to publisher sort

[yamusing]

I've got books with titles for example "publisher1 - book title", "publisher2 - book title", "publisher3 - book title" etc. already imported into calibre. How would I go about using the Search and Replace function to search for all the characters before the "-" and then move them over to the publisher field?

[yamusing]

Originally Posted by yamusing

I've got books with titles for example "publisher1 - book title", "publisher2 - book title", "publisher3 - book title" etc. already imported into calibre. How would I go about using the Search and Replace function to search for all the characters before the "-" and then move them over to the publisher field?

Forgot to add to only book titles with a space before the dash " -", such as titles like "book-title" doesn't get searched for.

[theducks]

Originally Posted by yamusing

I've got books with titles for example "publisher1 - book title", "publisher2 - book title", "publisher3 - book title" etc. already imported into calibre. How would I go about using the Search and Replace function to search for all the characters before the "-" and then move them over to the publisher field?

I do this in 2 steps: 1) copies to new home. 2) removes from original home
Bulk mode S&R both use the same REGEX search

search Title:
(.+?)\s-\s(.+?)

1)
Replace Publisher:
\1

2)
Replace Title:
\2

[yamusing]

Originally Posted by theducks

I do this in 2 steps: 1) copies to new home. 2) removes from original home
Bulk mode S&R both use the same REGEX search

search Title:
(.+?)\s-\s(.+?)

1)
Replace Publisher:
\1

2)
Replace Title:
\2

Tested it out but it doesn't seem to work right. With the title "publisher1 - book title" doing step one outputs "publisher1ook title" to the destination field publisher.

[theducks]

Originally Posted by yamusing

Tested it out but it doesn't seem to work right. With the title "publisher1 - book title" doing step one outputs "publisher1ook title" to the destination field publisher.

If you did it right, the test column (right side) would show just Publisher whuch was regex capture 1
Which should include everything up to: space dash space

Is there a second space dash space in the Title field?

[yamusing]

Originally Posted by theducks

If you did it right, the test column (right side) would show just Publisher whuch was regex capture 1
Which should include everything up to: space dash space

Is there a second space dash space in the Title field?

I've tested it on the title "Rowli Ng - Harry Potter" where the "Rowli Ng" is the publisher and "Harry Potter" is the book title. The test results as "Rowli Ngarry Potter" in the publisher column.

Search mode: "Regular expression"
Search field: "title"
Search for: "(.+?)\s-\s(.+?)"
Replace with: "\1"
Destination field: "publisher"

[theducks]

No quote marks in those terms?
I have no idea why the capture is grabbing that

The destination WAS blank. (or set it to Replace)?

[BetterRed]

@yamusing - try this



Not sure why the other one didn't work.

BR

[davidfor]

Originally Posted by BetterRed

@yamusing - try this

Attachment 172878

Not sure why the other one didn't work.

The "?" are for "non-greedy". In the original suggestion, the groups will only matching one character one each side of the space-dash-space.

Using the following might be safer:

^(.+?)\s-\s(.+?)$

That says you want to match the whole title where there is a space-dash-space in the middle. The non-greedy probably isn't needed unless there is a chance for two space-dash-space matches in the original title.

[yamusing]

Originally Posted by davidfor

The "?" are for "non-greedy". In the original suggestion, the groups will only matching one character one each side of the space-dash-space.

Using the following might be safer:

^(.+?)\s-\s(.+?)$

That says you want to match the whole title where there is a space-dash-space in the middle. The non-greedy probably isn't needed unless there is a chance for two space-dash-space matches in the original title.

thanks, this REGEX works without problem