<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:x="urn:schemas-microsoft-com:office:excel" 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=us-ascii">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.E-mailStijl20
{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:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:940992971;
mso-list-type:hybrid;
mso-list-template-ids:1558361900 -884468978 135462937 135462939 135462927 135462937 135462939 135462927 135462937 135462939;}
@list l0:level1
{mso-level-text:"\(%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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="NL-BE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Egbert,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Yes, the can be a solution for existing data.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">I think there are two lessons to be learned from this:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo1"><span lang="EN-US" style="mso-fareast-language:EN-US">Instruct cataloguers not to use the &-sign in data and to replace it while entering with “and” in fields that are used to build
links in iaH;<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo1"><span lang="EN-US" style="mso-fareast-language:EN-US">When you are dealing with fields that may contain “and”, use the escape code “"” in your link<o:p></o:p></span></li></ol>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Piet de Keyser<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Belgium<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Van:</b> Egbert De Smet <egbert.desmet@uantwerpen.be> <br>
<b>Verzonden:</b> woensdag 29 april 2020 9:12<br>
<b>Aan:</b> Piet De Keyser <piet.dekeyser@ucll.be>; isis-users@iccisis.org<br>
<b>Onderwerp:</b> Re: linking in iaH when data contains "and”<span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
</div>
<div id="divtagdefaultwrapper">
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;color:black">maybe you could use a replace() function on your v264 to replace '&' by 'and' ?<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<div id="Signature">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;color:black">Egbert de Smet<br>
Universiteit Antwerpen<o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;color:black">
<hr size="3" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span lang="EN-US" style="color:black">From:</span></b><span lang="EN-US" style="color:black"> isis-users <</span><span style="color:black"><a href="mailto:isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org"><span lang="EN-US">isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org</span></a></span><span lang="EN-US" style="color:black">>
on behalf of Piet De Keyser <</span><span style="color:black"><a href="mailto:piet.dekeyser@ucll.be"><span lang="EN-US">piet.dekeyser@ucll.be</span></a></span><span lang="EN-US" style="color:black">><br>
<b>Sent:</b> Tuesday, April 28, 2020 11:02 PM<br>
<b>To:</b> </span><span style="color:black"><a href="mailto:isis-users@iccisis.org"><span lang="EN-US">isis-users@iccisis.org</span></a></span><span lang="EN-US" style="color:black"><br>
<b>Subject:</b> [Isis-users] linking in iaH when data contains "and</span><span lang="EN-US">”</span><span lang="EN-US" style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12.0pt;color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p><span style="color:black">Dear colleagues,<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">A link in iaH can be a good idea to allow users to retrieve more of same. I wanted to put a link on the publisher’s name (which is in v264^b in my case). Normally my link would look like this:<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">'<a target="_self"<o:p></o:p></span></p>
<p><span style="color:black">href="/cgi-bin/wxis.exe/iah/scripts/?IsisScript=iah.xis&lang=en&base=CATALOG&nextAction=lnk&exprSearch=', mpu, v264^b,mpl,'&indexSearch=PU">',v264^b,'</a>',<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">but this will give you problems with publisher’s names in which e.g. the word “and” appears (e.g. Tailor and Francis). These data can only be retrieved successfully if they are put between quotation marks: “Tailor and Francis” (because
“and” is a Boolean operator). Now new problem: putting extra quotation marks in the link messes it up, because it already contains nested quotations marks. My sollution is to put the field between HTML escape codes (in this case "). Now the link becomes:<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">'<a target="_self"<o:p></o:p></span></p>
<p><span style="color:black">href="/cgi-bin/wxis.exe/iah/scripts/?IsisScript=iah.xis&lang=en&base=CATALOG&nextAction=lnk&exprSearch=', mpu<b>,"""v264^b""",</b>mpl,'&indexSearch=PU">',v264^b,'</a>',<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">Still one unsolved problem: the downloaded data is not: “Tailor and Francis”, but “Tailor & Francis”. My sollution doesn’t work with “&” in the data, but maybe not everything is soluble…<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">Piet de Keyser<o:p></o:p></span></p>
<p><span style="color:black">Belgium<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>