[Archivesspace_Users_Group] Double Comma Dilemma

Danielle Butler dbutler at cals.org
Sat Jan 19 15:17:50 EST 2019

After over a month of tweaking MySQL queries, we finally were able to get our duplicate commas eliminated.

For anyone who was hoping to do the same with their legacy data, this is the query that finally worked for us

UPDATE archival_object SET display_string = replace(display_string, ',,', ',');
UPDATE archival_object SET title = TRIM(TRAILING ',' FROM title)
where title like '%,';

Danielle Butler, CA | Archivist
Butler Center for Arkansas Studies | Central Arkansas Library System
100 Rock Street
Little Rock, AR 72201

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20190119/7d7d01c1/attachment.html>

More information about the Archivesspace_Users_Group mailing list