From f2e7bdde075dbdb50547dfe06ad3d5b1765f4106 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 7 Nov 2017 21:06:55 -0500 Subject: [PATCH] overzealous heuristic Signed-off-by: Jason Etheridge --- sql/base/base.sql | 4 ---- 1 files changed, 0 insertions(+), 4 deletions(-) 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')); -- 1.7.2.5