From: Jason Etheridge <jason@esilibrary.com>
Date: Wed, 8 Nov 2017 02:06:55 +0000 (-0500)
Subject: overzealous heuristic
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=f2e7bdde075dbdb50547dfe06ad3d5b1765f4106

overzealous heuristic

Signed-off-by: Jason Etheridge <jason@esilibrary.com>
---

diff --git a/sql/base/base.sql b/sql/base/base.sql
index 5c1174b..8de801a 100644
--- a/sql/base/base.sql
+++ b/sql/base/base.sql
@@ -481,10 +481,6 @@ CREATE OR REPLACE FUNCTION migration_tools.name_parse_out_fuller_last_first_midd
             suffix := 'II';
             temp := BTRIM(REGEXP_REPLACE( temp, E'II', '' ));
         END IF;
-        IF temp like '%IV%' THEN
-            suffix := 'IV';
-            temp := BTRIM(REGEXP_REPLACE( temp, E'IV', '' ));
-        END IF;
 
         IF temp ~ ',' THEN
             family_name = BTRIM(REGEXP_REPLACE(temp,'^(.*?,).*$','\1'));