MobileRead Forums - View Single Post - Regular Expression help: complicated remaming of titles

theducks · 03-30-2016, 10:37 AM

1) you have no (capture) pattern so it ='s all
2) you have a destination the same as source without modification by #1. The source of the duplicate values. The default (no destination specified) is SAME field

IMHO your work order is flawed

0) Have a complete plan that avoids traps in the end. Like resulting Duplicate Titles after cleanup. Each case is Unique (see red item below)

1*) Map fragments to destination fields (1 pass per destination field, minimum). S&R does not have a true 'Move'. You add / insert, then clean up
Normalize data. #, No., Issue: could be dropped (must as an Index for series) or made consistent

2) Cleanup. Remove data that now has a proper home

Fine Woodworking 202: Fine Woodworking Magazine № 202 (Winter 2009) Tools & Shops
Fine Woodworking 025: Fine Woodworking Magazine № 025 (Dec 1980)
Fine Woodworking 178: Fine Woodworking Magazine № 178

Lime is Series and Index I have always seemed to have to do this as 2 passes: Series (name), then series_index

This will also become the Primary Title, since it always exists (Duplicate tie breaker)

Magazine(-period) is just a TAG

eg Magazine-Quarterly, It need not be in the Title or Series

If you have a custom Sub-Title field, you could map the subject there
You could just leave (season) Subject in the title

BTW Issue number is a great Series_Index if you always have it.

Analog SF&F is a monthly (I use digits for month) EXCEPT the issue a Double Month issue

every year that breaks the simple digit plan

So, Now

Show (and Tell

) us your mapping plan. With source examples. Remember Pattern matching is a precise task. Every variation counts as a needed solution

Normalize your existing {title} eg the #, No. .... problem. This will reduce the needed solutions for the 'Move -Copy' phase

03-30-2016, 10:37 AM	#2
theducks Well trained by Cats Posts: 31,101 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	1) you have no (capture) pattern so it ='s all 2) you have a destination the same as source without modification by #1. The source of the duplicate values. The default (no destination specified) is SAME field IMHO your work order is flawed 0) Have a complete plan that avoids traps in the end. Like resulting Duplicate Titles after cleanup. Each case is Unique (see red item below) 1) Map fragments to destination fields (1 pass per destination field, minimum). S&R does not have a true 'Move'. You add / insert, then clean up Normalize data. #, No., Issue: could be dropped (must as an Index for series) or made consistent 2) Cleanup. Remove data that now has a proper home Fine Woodworking 202: Fine Woodworking Magazine № 202 (Winter 2009) Tools & Shops Fine Woodworking 025: Fine Woodworking Magazine № 025 (Dec 1980) Fine Woodworking 178: Fine Woodworking Magazine № 178 Lime is Series and Index I have always seemed to have to do this as 2 passes: Series (name), then series_index This will also become the Primary Title, since it always exists (Duplicate tie breaker) Magazine(-period) is just a TAG eg Magazine-Quarterly, It need not be in the Title or Series If you have a custom Sub-Title field, you could map the subject there You could* just leave (season) Subject in the title BTW Issue number is a great Series_Index if you always have it. Analog SF&F is a monthly (I use digits for month) EXCEPT the issue a Double Month issue every year that breaks the simple digit plan So, Now Show (and Tell ) us your mapping plan. With source examples. Remember Pattern matching is a precise task. Every variation counts as a needed solution Normalize your existing {title} eg the #, No. .... problem. This will reduce the needed solutions for the 'Move -Copy' phase