h1. Data Cleaups h2. Raw Data Cleaning _mostly around assigning series ids and cleaning up the names a little_ fixing Phonics : Phonics WAS 103280 0439944961 Phonics : Phonics NOW 103280 0439944961 Phonics : Phonics - A Complete Synthetic Programme PREPENDING 0 to ISBN 571226124 COMPLETE SET or PACK with no series id New Read and Respond: Complete Set A assigning last srs title as Read & Respond or Read & Respond or New Read and Respond TITLE like last Read & Respond WAS 9999308465 : NOW 101216 9999308465 Read & Respond : Complete Set A fixing New Read and Respond: Complete Set A WAS 101216 9999308465 Read & Respond : Complete Set A NOW 101216 9999308465 Read & Respond : Complete Set A - June Titles COMPLETE SET or PACK with no series id New Read and Respond: Complete Set B assigning last srs title as Read & Respond or Read & Respond or New Read and Respond TITLE like last Read & Respond WAS 9999308503 : NOW 101216 9999308503 Read & Respond : Complete Set B fixing New Read and Respond: Complete Set B WAS 101216 9999308503 Read & Respond : Complete Set B NOW 101216 9999308503 Read & Respond : Complete Set B - September Titles COMPLETE SET or PACK with no series id New 100 Literacy Hours: Complete Set assigning last srs title as All NEW 100 Literacy Hours or All NEW 100 Literacy Hours or New 100 Literacy Hours TITLE like last All NEW 100 Literacy Hours WAS 9999246796 : NOW 81785 9999246796 All NEW 100 Literacy Hours : Complete Set COMPLETE SET or PACK with no series id 100 Literacy Homeworks: Complete Set assigning last srs title as All NEW 100 Literacy Hours or All NEW 100 Literacy Hours or New 100 Literacy Hours GUESSING because of ':' series 100 Literacy Homeworks title Complete Set last srs title All NEW 100 Literacy Hours WAS 9999308546 : NOW 9999308546 100 Literacy Homeworks : Complete Set fixing 100 Literacy Homeworks: Complete Set WAS 9999308546 100 Literacy Homeworks : Complete Set NOW 4034 9999308546 100 Literacy Homeworks : Complete Set COMPLETE SET or PACK with no series id Smart Phonics Pack assigning last srs title as New Bright Ideas or New Bright Ideas or NBI fixing Classroom Resources WAS 9999248713 : Smart Phonics Pack NOW 99999 9999248713 Classroom Resources : Smart Phonics Pack COMPLETE SET or PACK with no series id 50 Literacy Hours for Less Able Learners Pack assigning last srs title as 50 Literacy Hours for Less Able Learners or 50 Literacy Hours for Less Able Learners or 50 Literacy Hours for Less Able Learners 9-11 TITLE like last 50 Literacy Hours for Less Able Learners WAS 9999244106 : NOW 83858 9999244106 50 Literacy Hours for Less Able Learners : COMPLETE SET or PACK with no series id 50 Literacy Hours for More Able Learners Pack assigning last srs title as 50 Literacy Hours for Less Able Learners or 50 Literacy Hours for Less Able Learners or 50 Literacy Hours for Less Able Learners 9-11 Fixing up Fuss 99298 99255 No Fuss No Fuss&English Photocopiables 5-7 English Photocopiables: Ages 5-7 No Fuss: English Photocopiables: Ages 5-7 0439965489 1088 5-7 No fuss, no filler, no waffle –great ideas at a price you’ll love!&&&&&* Tried and tested and chosen by the people who know best – teachers!&&&&&* The finest activities from some of our best-selling series.&&&&&* Use in lessons, for homework, to extend gifted and talented children or as further work for early finishers.&&&&&* Levelled and linked to the curriculum so it’s easy to find the right activity.&&&&&* Whatever you’re teaching, there’s a ready-made resource for you. 128 12.00 12.00 2006-01-23 2005-12-19 yes PK3098 Fixing up Fuss 99299 99255 No Fuss No Fuss&English Photocopiables 7-9 English Photocopiables: Ages 7-11 No Fuss: English Photocopiables: Ages 7-11 0439965497 1089 7-11 No fuss, no filler, no waffle –great ideas at a price you’ll love!&&&&&* Tried and tested and chosen by the people who know best – teachers!&&&&&* The finest activities from some of our best-selling series.&&&&&* Use in lessons, for homework, to extend gifted and talented children or as further work for early finishers.&&&&&* Levelled and linked to the curriculum so it’s easy to find the right activity.&&&&&* Whatever you’re teaching, there’s a ready-made resource for you. Book Paper or Softback 128 12.00 12.00 2006-01-23 2005-12-19 yes PK3099 Fixing up Fuss 100948 No Fuss&English Photocopiables Complete Set 9999248772 1090 24.00 20.00 yes PK3100 COMPLETE SET or PACK with no series id No Fuss:English Photocopiables Complete Set assigning last srs title as No Fuss or No Fuss or No Fuss TITLE like last No Fuss WAS 9999248772 : NOW 99255 9999248772 No Fuss : English Photocopiables Complete Set COMPLETE SET or PACK with no series id NBI: English Pack assigning last srs title as New Bright Ideas or New Bright Ideas or NBI TITLE like last New Bright Ideas WAS 9999308864 : NOW 82005 9999308864 New Bright Ideas : English Pack COMPLETE SET or PACK with no series id Creative Activities Complete Set assigning last srs title as Creative Activities for Plot, Character and Setting or Creative Activities for Plot, Character and Setting or Creative Activities for Plot, Character and Setting 9-11 fixing Creative Activities for Plot, Character and Setting Complete Set WAS 9999244114 : Creative Activities Complete Set NOW 26956 9999244114 Creative Activities for Plot, Character and Setting : Complete Set COMPLETE SET or PACK with no series id Speaking Complete set assigning last srs title as Speaking and listening or Speaking and listening or Speaking TITLE like last Speaking and listening WAS 9999118496 : NOW 19660 9999118496 Speaking and listening : fixing Speaking Complete set WAS 19660 9999118496 Speaking and listening : Speaking Complete set NOW 19660 9999118496 Speaking and listening : Complete Set Writing Guide Complete Set Found COMPLETE SET or PACK with no series id WGuide:Complete Set (5-7) assigning last srs title as Writing Guides or Writing Guides or WGuide TITLE like last Writing Guides WAS 0439976103 : NOW 4041 0439976103 Writing Guides : Complete Set (5-7) fixing DEAL WITH COMPLETE SETS - with extra text WAS 4041 0439976103 Writing Guides : Complete Set (5-7) NOW 4041 0439976103 Writing Guides : Complete Set 5-7 Writing Guide Complete Set Found COMPLETE SET or PACK with no series id WGuide:Complete Set (7-9) assigning last srs title as Writing Guides or Writing Guides or WGuide TITLE like last Writing Guides WAS 0439976111 : NOW 4041 0439976111 Writing Guides : Complete Set (7-9) fixing DEAL WITH COMPLETE SETS - with extra text WAS 4041 0439976111 Writing Guides : Complete Set (7-9) NOW 4041 0439976111 Writing Guides : Complete Set 7-9 Writing Guide Complete Set Found COMPLETE SET or PACK with no series id WGuide:Complete Set (9-11) assigning last srs title as Writing Guides or Writing Guides or WGuide TITLE like last Writing Guides WAS 043997612X : NOW 4041 043997612X Writing Guides : Complete Set (9-11) fixing DEAL WITH COMPLETE SETS - with extra text WAS 4041 043997612X Writing Guides : Complete Set (9-11) NOW 4041 043997612X Writing Guides : Complete Set 9-11 COMPLETE SET or PACK with no series id High Frequency Words Pack assigning last srs title as Scholastic Teacher Bookshop or Scholastic Teacher Bookshop or STB COMPLETE SET or PACK with no series id 50 Texts: Complete Set assigning last srs title as 50 Shared Texts or 50 Shared Texts or 50 Texts TITLE like last 50 Shared Texts WAS 9999118453 : NOW 17874 9999118453 50 Shared Texts : Complete Set fixing SLS:Grammar/Punct Full Set WAS 0439976162 : SLS:Grammar/Punct Full Set NOW 4049 0439976162 Scholastic Literacy Skills : Grammar/Punctuation Complete Set fixing SLS: Comprehension Full Set WAS 0439976146 : SLS: Comprehension Full Set NOW 4049 0439976146 Scholastic Literacy Skills : Comprehension Complete Set COMPLETE SET or PACK with no series id Creative Activities for Maths Problem Solving Complete Set assigning last srs title as Creative Activities or Creative Activities or Creative Activities for Maths Problem Solving 7-11 TITLE like last Creative Activities WAS 9999308945 : NOW 95679 9999308945 Creative Activities : COMPLETE SET or PACK with no series id 50 Maths Lessons For Less Able Learners: Complete Set assigning last srs title as 50 Maths Lessons for Less Able Learners or 50 Maths Lessons for Less Able Learners or 50 Maths Lessons For Less Able Learners TITLE like last 50 Maths Lessons for Less Able Learners WAS 9999248985 : NOW 94584 9999248985 50 Maths Lessons for Less Able Learners : Complete Set COMPLETE SET or PACK with no series id 100 Maths Homework and Assessment Activities: Complete Set assigning last srs title as 100 Maths Homework and Assessment Activities or 100 Maths Homework and Assessment Activities or 100 Maths Homework and Assessment Activities TITLE like last 100 Maths Homework and Assessment Activities WAS 9999308988 : NOW 94015 9999308988 100 Maths Homework and Assessment Activities : Complete Set COMPLETE SET or PACK with no series id All New 100 Maths Lessons: Complete Set assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons TITLE like last All New 100 Maths Lessons WAS 9999246788 : NOW 4079 9999246788 All New 100 Maths Lessons : Complete Set COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year R assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year 1 assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year 2 assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year 3 assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year 4 assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year 5 assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 Maths Lessons and Homework Activitites Pack Year 6 assigning last srs title as All New 100 Maths Lessons or All New 100 Maths Lessons or All New 100 Maths Lessons COMPLETE SET or PACK with no series id 100 MM Start:Complete Set assigning last srs title as 100 Mental Maths Starters or 100 Mental Maths Starters or 100 MM Start TITLE like last 100 Mental Maths Starters WAS 0439976219 : NOW 4052 0439976219 100 Mental Maths Starters : Complete Set Fixing up Fuss 99256 99255 No Fuss No Fuss&Maths Photocopiables 5-7 Maths Photocopiables: Ages 5-7 No Fuss: Maths Photocopiables: Ages 5-7 0439965500 1193 5-7 No fuss, no filler, no waffle –great ideas at a price you’ll love!&&&&&* Tried and tested and chosen by the people who know best – teachers!&&&&&* The finest activities from some of our best-selling series.&&&&&* Use in lessons, for homework, to extend gifted and talented children or as further work for early finishers.&&&&&* Levelled and linked to the curriculum so it’s easy to find the right activity.&&&&&* Whatever you’re teaching, there’s a ready-made resource for you. Book Paper or Softback 128 12.00 12.00 2006-01-23 2005-12-19 yes PK3203 Fixing up Fuss 99264 99255 No Fuss No Fuss&Maths Photocopiables 7-9 Maths Photocopiables: Ages 7-11 No Fuss: Maths Photocopiables: Ages 7-11 0439965519 1194 7-11 No fuss, no filler, no waffle –great ideas at a price you’ll love!&&&&&* Tried and tested and chosen by the people who know best – teachers!&&&&&* The finest activities from some of our best-selling series.&&&&&* Use in lessons, for homework, to extend gifted and talented children or as further work for early finishers.&&&&&* Levelled and linked to the curriculum so it’s easy to find the right activity.&&&&&* Whatever you’re teaching, there’s a ready-made resource for you. Book Paper or Softback 128 12.00 12.00 2006-01-23 2005-12-19 yes PK3204 Fixing up Fuss 100957 No Fuss&Maths Photocopiables Complete Set 9999248993 1195 24.00 20.00 yes PK3205 COMPLETE SET or PACK with no series id No Fuss:Maths Photocopiables Complete Set assigning last srs title as No Fuss or No Fuss or No Fuss TITLE like last No Fuss WAS 9999248993 : NOW 99255 9999248993 No Fuss : Maths Photocopiables Complete Set fixing Classroom Resources WAS 9999245676 : Time Tracker NOW 99999 9999245676 Classroom Resources : Time Tracker Fixing up Fuss 99266 99255 No Fuss No Fuss&Science Photocopiables 5-7 Science Photocopiables: Ages 5-7 No Fuss: Science Photocopiables: Ages 5-7 0439965527 1197 5-7 No fuss, no filler, no waffle –great ideas at a price you’ll love!&&&&&* Tried and tested and chosen by the people who know best – teachers!&&&&&* The finest activities from some of our best-selling series.&&&&&* Use in lessons, for homework, to extend gifted and talented children or as further work for early finishers.&&&&&* Levelled and linked to the curriculum so it’s easy to find the right activity.&&&&&* Whatever you’re teaching, there’s a ready-made resource for you. Book Paper or Softback 128 12.00 12.00 2006-01-23 2005-12-19 yes PK3207 Fixing up Fuss 99265 99255 No Fuss No Fuss&Science Photocopiables 7-9 Science Photocopiables: Ages 7-11 No Fuss: Science Photocopiables: Ages 7-11 0439965535 1198 7-11 No fuss, no filler, no waffle –great ideas at a price you’ll love!&&&&&* Tried and tested and chosen by the people who know best – teachers!&&&&&* The finest activities from some of our best-selling series.&&&&&* Use in lessons, for homework, to extend gifted and talented children or as further work for early finishers.&&&&&* Levelled and linked to the curriculum so it’s easy to find the right activity.&&&&&* Whatever you’re teaching, there’s a ready-made resource for you. Book Paper or Softback 128 12.00 12.00 2006-01-23 2005-12-19 yes PK3208 Fixing up Fuss 100958 No Fuss&Science Photocopiables Complete Set 9999249000 1199 24.00 20.00 PK3209 COMPLETE SET or PACK with no series id No Fuss:Science Photocopiables Complete Set assigning last srs title as No Fuss or No Fuss or No Fuss TITLE like last No Fuss WAS 9999249000 : NOW 99255 9999249000 No Fuss : Science Photocopiables Complete Set COMPLETE SET or PACK with no series id Horrible Science - Complete Set assigning last srs title as Horrible Science Teachers' Resources or Horrible Science Teachers' Resources or Horrible Science - Animals fixing Horrible Science - Complete Set WAS 9999249019 : Horrible Science - Complete Set NOW 83888 9999249019 Horrible Science Teachers' Resources : Complete Set COMPLETE SET or PACK with no series id RRS:Science Complete Set assigning last srs title as Ready Resources or Ready Resources or RRS TITLE like last Ready Resources WAS 9999118488 : NOW 4061 9999118488 Ready Resources : Science Complete Set COMPLETE SET or PACK with no series id HSD:Complete Set assigning last srs title as Handling Science Data or Handling Science Data or HSD TITLE like last Handling Science Data WAS 0439976308 : NOW 4075 0439976308 Handling Science Data : Complete Set COMPLETE SET or PACK with no series id 100 Sci Less:Complete Set assigning last srs title as 100 Science Lessons or 100 Science Lessons or 100 Sci Less TITLE like last 100 Science Lessons WAS 0439976324 : NOW 4039 0439976324 100 Science Lessons : Complete Set COMPLETE SET or PACK with no series id RRS: Geography Book Pack assigning last srs title as Ready Resources or Ready Resources or RRS TITLE like last Ready Resources WAS 999924680X : NOW 4061 999924680X Ready Resources : Geography Book Pack COMPLETE SET or PACK with no series id 100 History Lessons Complete Set assigning last srs title as Ready Resources or Ready Resources or RRS fixing DEAL WITH COMPLETE SETS - no extra text WAS 999930902X : 100 History Lessons Complete Set NOW 999930902X : 100 History Lessons Complete Set COMPLETE SET or PACK with no series id RRS:RE Complete Set assigning last srs title as Ready Resources or Ready Resources or RRS TITLE like last Ready Resources WAS 9999249043 : NOW 4061 9999249043 Ready Resources : RE Complete Set fixing Religious Education Complete Set WAS 4061 9999249043 Ready Resources : RE Complete Set NOW 4061 9999249043 Ready Resources : Religious Education Complete Set COMPLETE SET or PACK with no series id You Can: Interactive Whiteboard Complete Set assigning last srs title as You Can or You Can or You Can TITLE like last You Can WAS 9999249027 : NOW 94810 9999249027 You Can : Interactive Whiteboard Complete Set COMPLETE SET or PACK with no series id 100 ACTIVprimary Whiteboard Lessons: Complete Set assigning last srs title as 100 ACTIVprimary Whiteboard Lessons or 100 ACTIVprimary Whiteboard Lessons or 100 ACTIVprimary Whiteboard Lessons TITLE like last 100 ACTIVprimary Whiteboard Lessons WAS 9999309062 : NOW 100071 9999309062 100 ACTIVprimary Whiteboard Lessons : Complete Set COMPLETE SET or PACK with no series id Creative Activities Art Complete Set assigning last srs title as Creative Activities or Creative Activities or Creative Activities for Seasonal Art TITLE like last Creative Activities WAS 999924727X : NOW 95679 999924727X Creative Activities : fixing DEAL WITH COMPLETE SETS - no extra text WAS 95679 999924727X Creative Activities : Creative Activities Art Complete Set NOW 95679 999924727X Creative Activities : Creative Activities Art Complete Set COMPLETE SET or PACK with no series id 100 Assemblies Complete Set assigning last srs title as 100 Assemblies or 100 Assemblies or 100 Assemblies 7-11 TITLE like last 100 Assemblies WAS 9999246818 : NOW 90159 9999246818 100 Assemblies : fixing 100 Assemblies Complete Set WAS 90159 9999246818 100 Assemblies : 100 Assemblies Complete Set NOW 90159 9999246818 100 Assemblies : Complete Set fixing Values Education WAS 1864005270 : Values Education A NOW 1000002 1864005270 Values Education : Values Education A fixing Values Education WAS 1864005300 : Values Education B NOW 1000002 1864005300 Values Education : Values Education B fixing Values Education WAS 1864005335 : Values Education C NOW 1000002 1864005335 Values Education : Values Education C fixing Values Education WAS 186400536X : Values Education D NOW 1000002 186400536X Values Education : Values Education D fixing Values Education WAS 1864005394 : Values Education E NOW 1000002 1864005394 Values Education : Values Education E fixing Values Education WAS 1864005424 : Values Education F NOW 1000002 1864005424 Values Education : Values Education F COMPLETE SET or PACK with no series id Values Education Complete Set assigning last srs title as Scholastic Teacher Bookshop or Scholastic Teacher Bookshop or STB fixing Values Education WAS 9999309100 : Values Education Complete Set NOW 1000002 9999309100 Values Education : Values Education Complete Set COMPLETE SET or PACK with no series id You Can: Create a Calm Classroom Complete Set assigning last srs title as You Can or You Can or You Can TITLE like last You Can WAS 9999247245 : NOW 94810 9999247245 You Can : Create a Calm Classroom Complete Set COMPLETE SET or PACK with no series id NBI: PSHE Pack assigning last srs title as New Bright Ideas or New Bright Ideas or NBI TITLE like last New Bright Ideas WAS 9999309143 : NOW 82005 9999309143 New Bright Ideas : PSHE Pack COMPLETE SET or PACK with no series id SNPY: Complete Set assigning last srs title as Special Needs in the Primary Years or Special Needs in the Primary Years or SNPY TITLE like last Special Needs in the Primary Years WAS 9999309186 : NOW 81647 9999309186 Special Needs in the Primary Years : Complete Set fixing SNPY: Complete Set WAS 81647 9999309186 Special Needs in the Primary Years : Complete Set NOW 81647 9999309186 Special Needs in the Primary Years : Complete Set fixing Football Phonics WAS 9999248683 : Football Phonics 1 (LL07054) NOW 99999 9999248683 Classroom Resources : Football Phonics 1 fixing Football Phonics WAS 9999248691 : Football Phonics 2 (LL07055) NOW 99999 9999248691 Classroom Resources : Football Phonics 2 fixing Football Phonics WAS 9999248705 : Football Phonics 3 (LL07056) NOW 99999 9999248705 Classroom Resources : Football Phonics 3 COMPLETE SET or PACK with no series id Football Phonics Pack assigning last srs title as Special Needs in the Primary Years or Special Needs in the Primary Years or SNPY fixing Football Phonics WAS 9999249035 : Football Phonics Pack NOW 99999 9999249035 Classroom Resources : Football Phonics Pack COMPLETE SET or PACK with no series id Daily Brainteasers: Complete Set assigning last srs title as Daily Brainteasers or Daily Brainteasers or Daily Brainteasers TITLE like last Daily Brainteasers WAS 9999248764 : NOW 97722 9999248764 Daily Brainteasers : Complete Set COMPLETE SET or PACK with no series id You Can Create a thinking classroom complete set assigning last srs title as Daily Brainteasers or Daily Brainteasers or Daily Brainteasers fixing You Can Create a thinking classroom complete set WAS 9999309224 : You Can Create a thinking classroom complete set NOW 94810 9999309224 You can... : Create a thinking classroom complete set COMPLETE SET or PACK with no series id Thinking Skills:Complete Set assigning last srs title as Thinking Skills or Thinking Skills or Thinking Skills TITLE like last Thinking Skills WAS 999911850X : NOW 4073 999911850X Thinking Skills : Complete Set COMPLETE SET or PACK with no series id ROA:Complete Set assigning last srs title as Records of Achievement or Records of Achievement or ROA TITLE like last Records of Achievement WAS 999911847X : NOW 4074 999911847X Records of Achievement : Complete Set fixing Classroom Resources WAS 9999118577 : Merit Stickers Spring 2004 x 2 NOW 99999 9999118577 Classroom Resources : Merit Stickers Spring 2004 x 2 COMPLETE SET or PACK with no series id New Themes for Early Years: Complete Set assigning last srs title as You Can or You Can or You Can&Survive Your Early Years OfSted Inspection GUESSING because of ':' series New Themes for Early Years title Complete Set last srs title You Can WAS 9999305431 : NOW 9999305431 New Themes for Early Years : Complete Set fixing New Themes for Early Years: Complete Set WAS 9999305431 New Themes for Early Years : Complete Set NOW 99443 9999305431 Themes for Early Years : Complete Set COMPLETE SET or PACK with no series id Early Years Photocopiables: Complete Set assigning last srs title as You Can or You Can or You Can&Survive Your Early Years OfSted Inspection GUESSING because of ':' series Early Years Photocopiables title Complete Set last srs title You Can WAS 9999305474 : NOW 98375 9999305474 Early Years Photocopiables : Complete Set COMPLETE SET or PACK with no series id The Best of Nursery Education: Complete Set assigning last srs title as The Best of Nursery Education or The Best of Nursery Education or The Best of Nursery Education TITLE like last The Best of Nursery Education WAS 9999305512 : NOW 91290 9999305512 The Best of Nursery Education : Complete Set COMPLETE SET or PACK with no series id Fun Songs for Early Years: Complete Set assigning last srs title as Fun Songs for Early Years or Fun Songs for Early Years or Fun Songs for Early Years TITLE like last Fun Songs for Early Years WAS 9999305555 : NOW 30562 9999305555 Fun Songs for Early Years : Complete Set COMPLETE SET or PACK with no series id 10 Min Ideas EY:Complete Set assigning last srs title as 10-Minute Ideas for Early Years or 10-Minute Ideas for Early Years or 10 Min Ideas EY TITLE like last 10-Minute Ideas for Early Years WAS 9999247490 : NOW 18347 9999247490 10-Minute Ideas for Early Years : Complete Set COMPLETE SET or PACK with no series id FFEY: Complete Set assigning last srs title as Festival fun for the Early Years or Festival fun for the Early Years or FFEY TITLE like last Festival fun for the Early Years WAS 9999247504 : NOW 27366 9999247504 Festival fun for the Early Years : Complete Set COMPLETE SET or PACK with no series id Goals: Complete Set assigning last srs title as Goals for the Foundation Stage or Goals for the Foundation Stage or Goals TITLE like last Goals for the Foundation Stage WAS 0439976340 : NOW 4077 0439976340 Goals for the Foundation Stage : Complete Set fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439983363 100 Early Years Games : Learning for Ages 0-3 NOW 4070 0439983363 100 Early Years Games : Learning:0-3 Years fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439984343 100 Early Years Games : Language for Ages 0-3 NOW 4070 0439984343 100 Early Years Games : Language 0-3 fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439984769 100 Early Years Games : Number for Ages 0-3 NOW 4070 0439984769 100 Early Years Games : Number 0-3 fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439971292 100 Early Years Games : Our Senses for Ages 0-3 NOW 4070 0439971292 100 Early Years Games : Our Senses 0-3 fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439983355 100 Early Years Games : Learning for Ages 3-5 NOW 4070 0439983355 100 Early Years Games : Learning:3-5 Years fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439984580 100 Early Years Games : Language for Ages 3-5 NOW 4070 0439984580 100 Early Years Games : Language 3-5 Yrs fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439984777 100 Early Years Games : Number for Ages 3-5 NOW 4070 0439984777 100 Early Years Games : Number 3-5 fixing 100 Early Years Games 100 Learn:100 Number Games 0-3 WAS 4070 0439971225 100 Early Years Games : Our Senses for Ages 3-5 NOW 4070 0439971225 100 Early Years Games : Learn:Our Senses 3-5 COMPLETE SET or PACK with no series id 100 Early Years Games Pack 0-3 assigning last srs title as 100 Early Years Games or 100 Early Years Games or 100 Learn TITLE like last 100 Early Years Games WAS 9999244068 : NOW 4070 9999244068 100 Early Years Games : COMPLETE SET or PACK with no series id 100 Early Years Games Pack 3-5 assigning last srs title as 100 Early Years Games or 100 Early Years Games or 100 Learn TITLE like last 100 Early Years Games WAS 9999244076 : NOW 4070 9999244076 100 Early Years Games : COMPLETE SET or PACK with no series id Foundation Themes: Complete Set assigning last srs title as Foundation Themes or Foundation Themes or Foundation Themes TITLE like last Foundation Themes WAS 9999305598 : NOW 18057 9999305598 Foundation Themes : Complete Set COMPLETE SET or PACK with no series id TOD: Complete Set assigning last srs title as Themes On Display or Themes On Display or TOD TITLE like last Themes On Display WAS 9999250467 : NOW 4025 9999250467 Themes On Display : Complete Set COMPLETE SET or PACK with no series id SNEY: Complete set assigning last srs title as Special Needs in the Early Years or Special Needs in the Early Years or SNEY TITLE like last Special Needs in the Early Years WAS 9999305636 : NOW 4040 9999305636 Special Needs in the Early Years : Complete set fixing SNEY: Complete set WAS 4040 9999305636 Special Needs in the Early Years : Complete set NOW 4040 9999305636 Special Needs in the Early Years : Complete Set fixing You Can: KS1 set WAS 9999305679 : You Can: KS1 set NOW 94810 9999305679 You can... : KS1 Complete Set fixing New Read and Respond: KS1 Teacher resources WAS 9999305717 : New Read and Respond: KS1 Teacher resources NOW 101216 9999305717 New Read and Respond : KS1 Complete Set fixing Pocket Guides to the Curriculum: RE WAS 4027 0439017955 Pocket Guides to the Curriculum : Religious Education NOW 99999 0439017955 Classroom Resources : Pocket Guides to the Curriculum: RE COMPLETE SET or PACK with no series id Pocket Guides RE Pack of 10 assigning last srs title as Classroom Resources or Pocket Guides to the Curriculum or Pocket Guides RE TITLE like last Classroom Resources WAS 9999251455 : NOW 99999 9999251455 Classroom Resources : fixing Pocket Guides RE WAS 99999 9999251455 Classroom Resources : Pocket Guides RE Pack of 10 NOW 9999251455 Classroom Resources : Pocket Guides to the Curriculum: RE Pack of 10 h2. Title Cleanup _getting rid of some abbreviations as well as forcing Title Case..._ $t =~ s/KS(\d)/Key Stage $1/; $t =~ s/(\w+)/\u\L$1/g; # force Title Case # put prepositions into lower case again... $t =~ s/\b(of|the|for|on|by|a|to|at|an)\b/\L$1/ig; $t =~ s/: (of|the|for|on|by|a|to|at|an)\b/: \L$1/ig; $t =~ s/ For / for /g; $t =~ s/\bict/ICT/i; # forcing ICT into uppercase $t =~ s/(\s|\b)re(\b|\s)/ RE /i; # allow RE to be in uppercase $t =~ s/\' RE/\'re/g; # fix We' RE to We're (not the space after the ' $t =~ s/sen\b/SEN/i; # force SEN to uppercasse $t =~ s/Pshe/PSHE/i; # force PSHE into uppercase $t =~ s/^the/The/; # force The to titlecase if its the leading word $t =~ s/ a($| )/ A /; # force A to uppercase if its the first word $t =~ s/'S/'s/g; # force 's to lowercase $t =~ s/ Yr / Year /g; # Yr to Year $t =~ s/ Yrs / Years /g; # Yrs to Years # AGES - put ages into "(Ages #-#)" format if ($t =~ /\(Ages/) { # GOOD (Ages 4-7) format # add extra space, in case $t =~ s/\(Ages/ \(Ages/; } elsif ($t =~ /^Ages/) { # skip lines starting with Ages } elsif ($t =~ /\((\d+\-\d+)\)/) { # No 'Ages' in parens # (4-7) my $d = $1; $t =~ s/\(.[^\)]*\)/ \(Ages $d\)/; } elsif ($t =~ /\:(\d+\-\d+)/) { # colon No 'Ages' no parens # :4-7 my $m = $&; my $d = $1; $t =~ s/$m/ \(Ages $d\)/; } elsif ($t =~ /(Ages \d+\-\d+)/) { # no parens # Age 4-7 my $m = $&; $t =~ s/$m/ \($m\)/; } elsif ($t =~ /(?!Ages) (\d+\-\d+)/) { # no 'Ages' or parens # 4-7 my $m = $2; $t =~ s/$m/ \(Ages $1\)/; } $t =~ s/s\&M/s \&\; M/; # fix no fuss&math $t =~ s/^New //g; # remove leading 'New ' $t =~ s/Bright Ideas/New Bright Ideas/g; # put New back for NBI $t =~ s/ And / \&\; /i; # replace 'and' with ampersand $t =~ s/\'D/\'d/; # fix title case 'd issue $t =~ s/\'S/\'s/; # fix title case 's issue $t =~ s/\'R/\'r/; # fix title case 'r issue $t =~ s/\'N/\'n/; # fix title case 'n issue $t =~ s/\'T/\'t/; # fix title case 't issue $t =~ s/ .?With Cd.Rom.?//gi; # remove 'with Cd Rom' text $t =~ s/\& /\&\; /g; # html ampersand entity $t =~ s/\&\;/ \&\; /gi; $t =~ s/\;\s+the/\; The/g; # force The to be upper after an entity $t =~ s/ / /g; # removed extra spaces $t =~ s/for \(Ages/ \(Ages/; # remove 'for' in "for (Ages..." $t =~ s/\)s/\)/; # remove 's' in "(Ages 7-9)s" $t =~ s/\) (Year?)/\)/g; # get rid of years in (Ages 0-3) Years # fix up some R&R titles $t = "We're Going on A Bear Hunt" if ($t =~ /\*\* 240xl3/); # funny '** 240xl3' text $t = "The Suitcase Kid" if ($t =~ /Suitcase Kid \- Novel/); # bad title $t = "Farmer Duck" if ($t =~ /Farmer Duck\*\* 250xl/); # funny "** 250xl" text $t =~ s/Carries War/Carrie's War/g; # forgotten ' $t = "Peace at Last" if ($t =~ /Peace at Last\*/); # remove extra text at end... # FORMAT YOU CAN... TITLES with ellipsis over ... if ($t eq "You Can" || $t eq "You can...") { $t = "You Can \&\#8230\;"; # series title } $t =~ s/ / /g; # removed extra spaces $t =~ s/(.*)\: Complete Set/Complete Set/i; # remove colon (:) preceding "Complete Set"