<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr" style="text-align:left; direction:ltr;" bgcolor="#ffffff" text="#4c4c4c" link="#007aa6" vlink="#007aa6"><div>Hi,</div><div><br></div><div>I have the same problem with other databases - tag no 704.</div><div>I wrote the proc file using tag 704.</div><div>However, when I run it there is an error message</div><div> -</div><div><b>704 "^o20161114 02:06:39^djessica"</b></div><div><b>704 "^o20161124 11:00:45^dronel"</b></div><div>800 "-34:07"</div><div>807 "MD"</div><div>901 "OCCUPATION"</div><div>901 "VOCALIST - VOCATIONAL GUIDANCE"</div><div>902 "Interview"</div><div>906 "0"</div><div>913 "JE"</div><div>919 "Yes"</div><div>..x</div><div><a href="mailto:renate@renate-ubuntu">renate@renate-ubuntu</a>:~/abcdbases/sound/data$ mx sound <a href="mailto:proc=@switchv704.prc">proc=@switchv704.prc</a> copy=sound2 from=47000 to=47015 now -all</div><div><br></div><div>fatal: ^d20161114 02:06:39^ojessica</div><div></div><div>Here is the switch proc file:</div><div>proc('d704',('<704>', s(replace(replace(replace(v704,'^d','~o'),'^o','^d'),'~o','^o')), '</704>',)),(v704/)</div><div><br></div><div>Where is the error?</div><div>Thanks for the help.</div><div>Renate</div><div><br></div><div></div><div><br></div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Eustache,</p>
<p><br>
</p>
<p>indeed for some period there was a bug in the script to store the v980 'operator and date' field where ^o and ^d were switched.</p>
<p>To repair this you could apply, on the records where this is the case, the following proc :
<br>
</p>
<p></p>
<div>------------------ cut here for proc 'switchv980.prc'<br>
</div>
<div>proc(<br>
'd980',<br>
( '<980>', s(replace(replace(replace(v980,'^d','~o'),'^o','^d'),'~o','^o')), '</980>',)<br>
),<br>
(v980/) </div>
<div>------------------ end of proc 'switchv980.prc'</div>
<div>with the command : <br>
</div>
<div>mx marc proc=@switchv980.prc copy=marc now -all</div>
<div><br>
</div>
<p></p>
<p>If you only want to have it correctly displayed (not really changing the records), you can simply use the PFT :
<br>
</p>
<p></p>
<div>replace(replace(replace(v980,'^d','~o'),'^o','^d'),'~o','^o')</div>
<p></p>
<p>and if you have mixed records, with and without the problem, you can check whether ^o contains '20' at the beginning before applying the replace() :
<br>
</p>
<p>if (v980^o*0.2='20' then .... fi</p>
<p><br>
</p>
<p>The replace command has to be used 3 times (instead of 2) because first you have to set aside the date subfield marked as ~o, then switch the two subfields ^d and ^o, then put the ~o value in ^o. A bit complicated but it works.<br>
</p>
<p><br>
</p>
<div id="Signature">
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> isis-users <isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org> on behalf of Eustache Mêgnigbêto <eustache.megnigbeto@outlook.com><br>
<b>Sent:</b> Saturday, June 8, 2019 8:09 AM<br>
<b>To:</b> isis-users@iccisis.org<br>
<b>Subject:</b> [Isis-users] Changes in OD field structure</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US">Dear all,</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US">I download abcd (version 2.0f, December 2018) to replace the old version I was using.</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US">In one of my databases, I have an operator and date (OD) field. Once I saved the first record with this new version, I noticed that the OD field did not display as expected for the new record. I browsed some existing records and found that
the field displays normally. Inspecting the records with the “sin format” internal format, I discovered that the structure is not the same as in the existing records : the subfields (d and o) are permuted so instead of storing the date in ^d and the operator
in ^o, the new version stores them in ^o and ^d respectively. </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US">How can I change ?</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US">Thank you in advance.</span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span lang="EN-US"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
<span style="" lang="EN-US"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
====================================================================</p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
Eustache Mêgnigbêto</p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
09 BP 477 Saint Michel, Cotonou (République du Bénin)</p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
</div>
</div>
</div>
<pre>_______________________________________________</pre><pre>isis-users mailing list</pre><pre><a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a></pre><pre>To manage your own subscription options go to: <a href="http://lists.iccisis.org/listinfo/isis-users">http://lists.iccisis.org/listinfo/isis-users</a></pre><pre>Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a></pre><pre><br></pre></blockquote><div><span><pre>-- <br></pre>
<meta http-equiv="Content-Type" content="text/html; CHARSET=UTF-8">
<meta name="GENERATOR" content="GtkHTML/4.2.2">
<table cellspacing="0" cellpadding="0" width="100%">
<tbody><tr>
<td>
Renate Morgenstern<br>
Tel.: +264 61 242124<br>
Cell: +264 81 2910284<br>
Fax: 088637518<br>
Windhoek, Namibia
</td>
</tr>
</tbody></table>
</span></div></body></html>