[Archivesspace_Users_Group] Double Comma Dilemma

[Danielle Butler]

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
www.butlercenter.org<http://www.butlercenter.org/>
100 Rock Street
Little Rock, AR 72201
501-320-5724

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