3. Preparing database text for publication

The following should be checked and done before exporting the edition for publication:

• Check for en-dashes in various parts of the edition - in most cases they should be hyphens
• Check for dodgy app notes (see below)
• Check for repeated app entries (same word(s), same ms. ref)

These are older and might need some revision:

• Remove dodgy app notes (i.e. ones containing <i> or ‘’).
• Standardise [lit. blah] etc. [done]
• Fix metrical annotation - ´ | ` etc. [?]
• Fix Greek and other non-ReykholtTimes characters.
• Fix page/note references: s/(\d+),?\s*n\.\s*(\d)+/$1 n. $2/ or equivalent. [mostly done]
• check for upper case note lemmata
• Also check anm. references. [done]
• Fix ReykholtTimes styles by applying the following:

UPDATE notes
SET note=LEFT(SUBSTRING(note,43),LENGTH(note)-49)
WHERE note LIKE '<span style="font-family: ReykholtTimes;">%'
AND note LIKE '%</span>'

UPDATE skalds
SET biography=LEFT(SUBSTRING(biography,43),LENGTH(biography)-49)
WHERE biography LIKE '<span style="font-family: ReykholtTimes;">%'
AND biography LIKE '%</span>'

UPDATE verses
SET intro=LEFT(SUBSTRING(intro,43),LENGTH(intro)-49)
WHERE intro LIKE '<span style="font-family: ReykholtTimes;">%'
AND intro LIKE '%</span>'

UPDATE verses
SET editions=LEFT(SUBSTRING(editions,43),LENGTH(editions)-49)
WHERE editions LIKE '<span style="font-family: ReykholtTimes;">%'
AND editions LIKE '%</span>'

UPDATE verses
SET context=LEFT(SUBSTRING(context,43),LENGTH(context)-49)
WHERE context LIKE '<span style="font-family: ReykholtTimes;">%'
AND context LIKE '%</span>'

References