<div dir="ltr">Thanks, Steve. As you correctly surmised, the EAD files are already imported, so it is too late to use XSLT or otherwise manipulate the files to strip out the punctuation.<div><br></div><div>Our instance of ArchivesSpace is hosted, so I don't think we can try the MySQL approach on our own. Lyrasis would have to help us with that. </div><div><br></div><div>As I mentioned, I really thought I had seen this (some way for the interface to have a display rule of some kind) in a JIRA as an requested feature. Double periods might be harder to address because of the occasional use of ellipses, but double commas should be easy to screen out and are our biggest issue anyway.</div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jun 27, 2017 at 4:31 PM, Majewski, Steven Dennis (sdm7g) <span dir="ltr"><<a href="mailto:sdm7g@eservices.virginia.edu" target="_blank">sdm7g@eservices.virginia.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div><br>
</div>
<div>May be able to be fixed in EAD import. </div>
<div>Or, perhaps added to pre-flight schematrons and fixed in XSLT before import, since there are already a number of required fixes. </div>
<div><br>
</div>
<div>But that would be too late to fix resources you’ve already imported. </div>
<div><br>
</div>
<div>Those, you can fix it in MySQL with something like:</div>
<div><br>
</div>
<div>
<div>select count(*) from archivesspace.archival_object WHERE title LIKE '%,,%';</div>
<div>SET SQL_SAFE_UPDATES=0;</div>
<div>UPDATE archivesspace.archival_object </div>
<div>SET </div>
<div> title = REPLACE(title, ',,', ',')</div>
<div>WHERE</div>
<div> title LIKE '%,,%';</div>
<div>select count(*) from archivesspace.archival_object WHERE title LIKE '%,,%';</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>except repeat the archival_object.title update for archival_object.display_<wbr>string, resource.title, accession.title, and accession.display_string as needed. ( I think that's all of them. ) </div>
<div><br>
</div>
<div>May require triggering a reindex afterwards. </div>
<div><br>
</div>
<div><br>
</div>
<div>Note: I find too many false positives using regex search rlike: display_string rlike "[.,;],”</div>
<div>i.e. strings with an abbrev., : “… U.S. Commissioners, <a href="http://et.al" target="_blank">et.al</a>., 1931-56;” or "Photographs, India, Thomas Gampper, M.D., undated” . And searching for double periods ( like “%..%” ) mostly brings up intended ellipses in my sample, so if you want
to try any other patterns, you should inspect the search results first. </div>
<div><br>
</div>
<div><br>
</div>
<div>The above is all assuming that the problem is in the database and not just some display string constructed on the fly. I’ve found some matching “,,” instances in my sample, so that’s my guess at the source of the problem. However, I have no way
to search display only instances other than by eyeball. ( Reminds me of the joke about the drunk looking for his keys under the streetlight! ;-) </div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>— Steve Majewski</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<br>
<div>
<blockquote type="cite"><div><div class="h5">
<div>On Jun 27, 2017, at 4:28 PM, Lara Friedman-Shedlov <<a href="mailto:ldfs@umn.edu" target="_blank">ldfs@umn.edu</a>> wrote:</div>
<br class="m_-317466492312664052Apple-interchange-newline">
</div></div><div><div><div class="h5">
<div dir="ltr">I was sure I had seen a JIRA issue for this a while back, but now I can't find it. We have thousands of finding aids imported from EAD that have punctuation (commas and periods) at the end of the unittitle and/or unitdate fields. Since
ArchivesSpace automatically inserts commas between unittitles and unitdates, you end up with double punctuation. Rather than edit thousands and thousands of records to remove this superfluous punctuation, is there a way for ASpace to just ignore it? Please
say yes! :-)
<div><br>
</div>
<div>/ Lara Friedman-Shedlov</div>
<div>
<div><br>
</div>
<div>
<div>-- <br>
<div class="m_-317466492312664052gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>______________________________<wbr>___<br>
</div>
<div><br>
<div>Lara D. Friedman-Shedlov<br>
<a href="http://www.lib.umn.edu/ymca" style="font-size:12.8px" target="_blank">Kautz Family YMCA Archives</a> | University of Minnesota Libraries<br>
<a href="mailto:ldfs@umn.edu" target="_blank">ldfs@umn.edu</a> | <a href="tel:(612)%20626-7972" value="+16126267972" target="_blank">612.626.7972</a> | </div>
<div><br>
</div>
<div><a href="http://www.facebook.com/yarchives" style="color:rgb(17,85,204);font-size:12.8px" target="_blank"><img alt="www.facebook.com/IHRCA" src="http://i.imgbox.com/6DCAk0cT.png" height="35" width="35"></a><span style="font-size:12.8px"> </span><a href="https://twitter.com/yarchives" style="color:rgb(17,85,204);font-size:12.8px" target="_blank"><img alt="https://twitter.com/yarchives" src="http://i.imgbox.com/JlcfS0i5.png" height="35" width="35"></a><br>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
</div>
</blockquote>
</div>
<br>
</div>
<br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>_________________________________<br></div><div><br><div>Lara D. Friedman-Shedlov<br><a href="http://www.lib.umn.edu/ymca" style="font-size:12.8px" target="_blank">Kautz Family YMCA Archives</a> | University of Minnesota Libraries<br><a href="mailto:ldfs@umn.edu" target="_blank">ldfs@umn.edu</a> | 612.626.7972 | </div><div><br></div><div><a href="http://www.facebook.com/yarchives" style="color:rgb(17,85,204);font-size:12.8px" target="_blank"><img alt="www.facebook.com/IHRCA" src="http://i.imgbox.com/6DCAk0cT.png" height="35" width="35"></a><span style="font-size:12.8px"> </span><a href="https://twitter.com/yarchives" style="color:rgb(17,85,204);font-size:12.8px" target="_blank"><img alt="https://twitter.com/yarchives" src="http://i.imgbox.com/JlcfS0i5.png" height="35" width="35"></a><br><br></div></div></div></div></div></div>
</div>