-- SourceTemplate-AncestryRecord-cleaned.sql
/* 2023-05-02 Tom Holden ve3meo
Cleans [Author] output and removes switches for "n.p", "n.d."; refines punctuation
in the "uneditable", built-in Ancestry Record template used by
TreeShare downloads of Ancestry Sources, resulting in cleaner
Footnotes and Bibliography.

Restore original by using SourceTemplate-AncestryRecord-Reset.sql.
*/

UPDATE SourceTemplateTable 
SET
   Name = 'Ancestry Record (cleaned)'
   ,Description = 'Ancestry.com record source, sentences customised using SQLite to suppress "n.p.", "n.d." and improper punctuation.'  
   ,Footnote      = '<[Author], ><i>[Title]</i>< (<[PubPlace]><: [Publisher], ><[PubDate]>)><, [Page]>.'
   ,ShortFootnote = '<[Author:Surname], |[Author], ><i>[Title:Abbrev]</i><, [Page]>.'
   ,Bibliography  = '<?[Author:Surname]|[Author:Reverse]. |<[Author]. >><i>[Title]</i>.<< [PubPlace]><: [Publisher]>< [PubDate]>.>'
WHERE TemplateID = 439 -- Ancestry Record template
;