<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:Wingdings}
@font-face
{font-family:Wingdings}
@font-face
{font-family:Calibri}
@font-face
{font-family:Verdana}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{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"}
span.E-mailStijl17
{font-family:"Verdana","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
ol
{margin-bottom:0cm}
ul
{margin-bottom:0cm}
-->
</style><style type="text/css" id="owaParaStyle"></style>
</head>
<body lang="NL" link="blue" vlink="purple" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hi Peter,
<div><br>
</div>
<div>Regarding your first question:</div>
<div><br>
</div>
<div>You could replace "o" using a program like GMOD into e.g. ^bo. After this you can export subfield ^b into another field (using an export FST).</div>
<div><br>
</div>
<div>Regarding your second question:</div>
<div><br>
</div>
<div>Just export only the records that contain v959^o (using e.g. DOS Isis, after a search "? p(v959^o)" etc.).</div>
<div><br>
</div>
<div>For a one-time job these old instruments, which we all know very well, may still offer a quick solution.</div>
<div><br>
</div>
<div>Piet de Keyser</div>
<div>Belgium<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF973410" style="direction: ltr; "><font face="Tahoma" size="2" color="#000000"><b>Van:</b> isis-users-bounces@iccisis.org [isis-users-bounces@iccisis.org] namens Hessels, Peter [P.Hessels@kit.nl]<br>
<b>Verzonden:</b> vrijdag 17 augustus 2012 16:14<br>
<b>Aan:</b> isis-users@iccisis.org<br>
<b>Onderwerp:</b> [Isis-users] MX and proc<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"">Dear all,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif""> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">I need your help in processing a database, using the mx tool.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">I have imported a file from a database (120.000 records) and all went well. There are two problems left:</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""><span style="">1)<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">The control number from the original systems in mixed up: it contains the control number from the imported system. That is OK. But if the records has been copied
from Worldcat, also the Worldcat control number is in the same field. A normal control number would be 12345, if the origin is Worldcat, the controlnumber would be like 12345ocn101112. I want to copy the part ocn101112 to another field. How could I do
that?<br>
I tried the Gsplit (mx dbase proc='Gsplit=1=o' create=newdb now all) but apparently the Gsplit does not work with the letter o.
</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""><span style="">2)<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">From this imported file I created another database (loanobjects). From this database I want to delete records that do not have a specific value in field 959^o.
The logic would be like: <br>
if (field 959^o is not one of (BON,BO,LES,ATL)) then (delete this record).<br>
How could I accomplish this?</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">Any suggestions? I would be very grateful
</span><span lang="EN-US" style="font-size:10.0pt; font-family:Wingdings">J</span><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">Kind regards,</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif""> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt; font-family:"Verdana","sans-serif"">Peter</span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>