Quote:
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"