From ddc6062c9bf61d4684bb9cbbf8a76ea9b39eae07 Mon Sep 17 00:00:00 2001
From: Stevan Earl <stevan.earl@asu.edu>
Date: Sun, 14 Jun 2026 16:00:19 +0000
Subject: [PATCH] Problem #84: trailing spaces in follow.fol_cl_community_id

---
 conversion/clean.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/conversion/clean.sql b/conversion/clean.sql
index 087a842..a290aec 100644
--- a/conversion/clean.sql
+++ b/conversion/clean.sql
@@ -304,6 +304,15 @@ UPDATE follow
   SET fol_b_animid = UPPER(fol_b_animid)
   WHERE fol_b_animid <> UPPER(fol_b_animid);
 
+--
+-- Get rid of trailing spaces from follow.fol_cl_community_id
+-- Problem #84
+--
+UPDATE follow
+  SET fol_cl_community_id = RTRIM(fol_cl_community_id)
+  WHERE fol_cl_community_id <> RTRIM(fol_cl_community_id);
+
+
 --
 -- follow_arrival
 --
-- 
2.34.1