<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Roboto;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.fieldname
{mso-style-name:fieldname;}
span.labelfield
{mso-style-name:labelfield;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Thanks, Lesley.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sorry, I could have just done an all titles search for <U+fffd>.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ll take a look and see if I can’t get a solution to you as a going away present
<span style="font-family:"Segoe UI Emoji",sans-serif">😊</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Also, just some background, <U+fffd> is a generic Unicode replacement character used when an incoming character can’t be identified.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This issue probably stems from a mismatch between the encoding of the incoming record and the encoding specified in the import profile or configuration.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I see 172 records with this character, of various ages. But some where created yesterday or today, like this one: 992512785402818<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I don’t see any import jobs. Was this record pushed into Alma via Connexion, maybe?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Wade Guidry<o:p></o:p></p>
<p class="MsoNormal">Library Consortium Services Manager, WACTCLC<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:wadeg@bigbend.edu"><span style="color:blue">wadeg@bigbend.edu</span></a><o:p></o:p></p>
<p class="MsoNormal">(509) 760-4474<o:p></o:p></p>
<p class="MsoNormal"><a href="http://www.wactclc.org/"><span style="color:blue">http://www.wactclc.org</span></a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <wactclc-alma-bounces@lists.ctc.edu>
<b>On Behalf Of </b>Lesley Caldwell<br>
<b>Sent:</b> Thursday, March 24, 2022 4:07 PM<br>
<b>To:</b> WACTCLC Alma Discussion <wactclc-alma@lists.ctc.edu><br>
<b>Subject:</b> Re: [Wactclc-alma] Norm Rule to remove rule <U+fffd><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0" width="100%" style="width:100.0%;background:#F2DEA2;border:solid #A57D03 1.0pt">
<tbody>
<tr>
<td style="border:none;padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="color:#A57D03">CAUTION:</span></b><span style="color:black"> Originated outside our network. Do not click links or open attachments unless you validate the sender.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span class="fieldname"><b><span style="font-size:10.5pt;font-family:Roboto;color:#555555;background:white">MMS ID:</span></b></span><span style="font-size:10.5pt;font-family:Roboto;color:#555555;background:white"> <span class="labelfield">992513085002818</span></span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">wactclc-alma-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Guidry, Wade<br>
<b>Sent:</b> Thursday, March 24, 2022 3:28 PM<br>
<b>To:</b> WACTCLC Alma Discussion <<a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a>><br>
<b>Subject:</b> Re: [Wactclc-alma] Norm Rule to remove rule <U+fffd><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt;margin-bottom:7.5pt">
<p class="MsoNormal" style="line-height:12.0pt;background:#F5EF3A"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">CAUTION:</span></b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"> This email originated
from outside Pierce College. Do not click links or open attachments unless you have confirmed this is an authentic message from sender and know the content is safe. If you are unsure, contact the Help Desk at 253-964-6373 or email
<a href="mailto:Helpdesk@pierce.ctc.edu">Helpdesk@pierce.ctc.edu</a> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal">Lesley, can you share the MMSID of an example record?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Wade Guidry<o:p></o:p></p>
<p class="MsoNormal">Library Consortium Services Manager, WACTCLC<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:wadeg@bigbend.edu"><span style="color:blue">wadeg@bigbend.edu</span></a><o:p></o:p></p>
<p class="MsoNormal">(509) 760-4474<o:p></o:p></p>
<p class="MsoNormal"><a href="https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org%2f&c=E,1,rintnvg7a2mA7kL6FsZcy-ZbjtmLjsRq1GTNK4tEt_uZp1jWbFseW37tFAJwiXW0ww9Lhj1vE9dSxvKTR6vFT-jRuabc2Ddf-xDd-7fKsXrwn241CZ_Y&typo=1"><span style="color:blue">http://www.wactclc.org</span></a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">wactclc-alma-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Lesley Caldwell<br>
<b>Sent:</b> Thursday, March 24, 2022 2:35 PM<br>
<b>To:</b> <a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a><br>
<b>Subject:</b> [Wactclc-alma] Norm Rule to remove rule <U+fffd><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0" width="100%" style="width:100.0%;background:#F2DEA2;border:solid #A57D03 1.0pt">
<tbody>
<tr>
<td style="border:none;padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="color:#A57D03">CAUTION:</span></b><span style="color:black"> Originated outside our network. Do not click links or open attachments unless you validate the sender.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">One last question. :) I’m working on another normalization rule that we can’t quite get right! Victoria found
<a href="https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fdevelopers.exlibrisgroup.com%2fblog%2falma-indication-rule-for-bad-diacritics%2f&c=E,1,s94jd0nGScrqxwy_ndxouim4zR8zNOfCA-L_ywUETRgJ5K7tFU5zWurCiyzNLcbaGaO3H5RbGNknPPhHWyBderifsnGy_Q_I7Q_ur48q756l3OLW_zqKAqY,&typo=1">
this indication rule</a>, but we don’t just want to find the diacritics, we also want to remove them.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We’ve tried:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">rule "Contains <U+fffd> in 0XX or 1XX or 2xx or 3xx or 4xx or 5xx or 6XX or 7XX or 8xx fields"<o:p></o:p></p>
<p class="MsoNormal">when<o:p></o:p></p>
<p class="MsoNormal"> ((exists "0**.*.*<U+fffd>*") OR (exists "1**.*.*<U+fffd>*") OR (exists "2**.*.*<U+fffd>*") OR (exists "3**.*.*<U+fffd>*") OR (exists "4**.*.*<U+fffd>*") OR (exists "5**.*.*<U+fffd>*") OR (exists "6**.*.*<U+fffd>*") OR (exists "7**.*.*<U+fffd>*")
OR (exists "8**.*.*<U+fffd>*"))<o:p></o:p></p>
<p class="MsoNormal">then<o:p></o:p></p>
<p class="MsoNormal">replaceContents "<U+fffd>" with ""<o:p></o:p></p>
<p class="MsoNormal">end<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">rule "Contains <U+fffd> in 0XX or 1XX or 2xx or 3xx or 4xx or 5xx or 6XX or 7XX or 8xx fields"<o:p></o:p></p>
<p class="MsoNormal">when<o:p></o:p></p>
<p class="MsoNormal"> (exists "<U+fffd>")<o:p></o:p></p>
<p class="MsoNormal">then<o:p></o:p></p>
<p class="MsoNormal">replaceContents "<U+fffd>" with ""<o:p></o:p></p>
<p class="MsoNormal">end<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does anything wrong stick out to anyone?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td colspan="2" style="padding:0in 0in 3.75pt 0in">
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#900027">Lesley Caldwell<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333">Systems and Instruction Librarian</span></i><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333">Pierce College</span></b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="20" valign="top" style="width:15.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#900027">p:<o:p></o:p></span></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333">253-840-8420<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="20" valign="top" style="width:15.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#900027">a:<o:p></o:p></span></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333">1601 39th Ave SE, Puyallup, WA 98374<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="20" valign="top" style="width:15.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#900027">w:<o:p></o:p></span></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333"><a href="http://www.pierce.ctc.edu/"><span style="color:#333333">www.pierce.ctc.edu</span></a> </span><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#900027">e:</span><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#333333"> <a href="mailto:LCaldwell@pierce.ctc.edu">LCaldwell@pierce.ctc.edu</a><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:3.75pt 0in 7.5pt 0in">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><img border="0" width="270" height="48" style="width:2.8166in;height:.5in" id="Picture_x0020_1" src="cid:image001.png@01D83FA0.0FBD6FA0" alt="pierce college logo"></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="20" colspan="2" valign="top" style="width:15.0pt;padding:0in 0in 0in 0in">
</td>
</tr>
<tr>
<td colspan="2" valign="top" style="padding:6.0pt 0in 7.5pt 0in"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>