From 9c114acb624b63f6964c5514f2a97a62b8a6f78f Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Mon, 11 May 2026 18:33:18 +0000 Subject: [PATCH] Resolve problem #62 (cherry picked from commit 9f55a8f0fbcb76b16033c1791256b74c3ffd1dd4) --- conversion/clean.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index 047e04a..07858c7 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -254,6 +254,12 @@ UPDATE follow_arrival SET fa_fol_b_focal_animid = RTRIM(fa_fol_b_focal_animid) WHERE follow_arrival.fa_fol_b_focal_animid <> RTRIM(fa_fol_b_focal_animid); +-- +-- Remove trailing spaces from arrival Problem #62 +UPDATE follow_arrival + SET fa_b_arr_animid = RTRIM(fa_b_arr_animid) + WHERE follow_arrival.fa_b_arr_animid <> RTRIM(fa_b_arr_animid); + -- -- Update the follow_arrival.fa_type_of_cycle -- -- 2.34.1