View Single Post
Old 03-03-2019, 06:04 PM   #5
excaliber
Connoisseur
excaliber began at the beginning.
 
excaliber's Avatar
 
Posts: 59
Karma: 10
Join Date: Nov 2013
Device: Samsung Galaxy Tab 2 10.1 P5110
@BetterRed: Thanks that did help!

I could extract the authors from the title field like this:
Search field: title
Search For: -[a-zA-Z0-9()\s]*
Replace with: (empty)
Destination field: authors
Search mode: Regular expression
Mode: Replace Field
Split results: (yes)


For the Publication Date I used this:
Search field: title
Search For: [a-zA-Z()\s,-]*\s*
Replace with: (empty)
Destination field: pubdate
Search mode: Regular expression
Mode: Replace Field
Split results: (no)


but it worked well only if there were no other numbers in the title field.

Keeping only the right title was also complicated and didn't go well either.
excaliber is offline   Reply With Quote