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
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group