<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Ernesto,</p>
<p><br>
</p>
<p>for your information, this is the solution which I sent to Renate, and she confirmed it works perfectly :</p>
<p>======= </p>
<p></p>
<blockquote type="cite" style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px; margin: 0px 0px 0px 0.8ex; border-left: 2px solid rgb(114, 159, 207); padding-left: 1ex;">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size: 12pt;">
<p><br class="Apple-interchange-newline">
try this proc :<br>
</p>
<p></p>
<div>'d301',<br>
(<br>
if iocc > 3 then<br>
'<301>',v301,'</301>'<br>
else<br>
continue<br>
fi<br>
)<br>
<br>
</div>
<p></p>
<p>That will delete the first 3 occurrences of v301.</p>
<p><br>
</p>
<p>In your case you might want to do this only if there are more than 3 occurrences ? Then put the whole proc inside another if :<br>
</p>
<p>if nocc(v301) >3 then<br>
</p>
<p> 'd301',<br>
</p>
<div> (<br>
if iocc > 3 then<br>
'<301>',v301,'</301>'<br>
else<br>
continue<br>
fi<br>
)</div>
<div>fi<br>
</div>
</div>
</blockquote>
<div>
<div dir="ltr" style="font-size: 12pt;">
<div><br>
</div>
</div>
</div>
<br>
<p></p>
<p>==========</p>
<p>I am currently struggling, apart from health issues (right-hand surgery), with updating EmpWeb. No more transactions are performed when using Java more recent than version 7, even after updating the
<span>mysql-connector-java-3.1.12-bin.jar with a more recent one. Is there any way of contacting Barzilai or Ciro about this ? </span></p>
<p><br>
</p>
<p><br>
</p>
<p>By the way, how is your health nowadays ? Still able to do some work ? Or just enjoying life there, if not too much affected by corona ?</p>
<p><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 face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> isis-users <isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org> on behalf of spinaker <spinaker@adinet.com.uy><br>
<b>Sent:</b> Thursday, March 4, 2021 7:46 PM<br>
<b>To:</b> rmorgenstern@iway.na; isis-users@iccisis.org<br>
<b>Subject:</b> Re: [Isis-users] Help with Cisis - deleting only certain occurrences</font>
<div> </div>
</div>
<div>
<div class="moz-cite-prefix">Dear Renate</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">The fields are repeatable, so if you remove one occurrence then the remaining ones are automatically renumbered<br>
Due to the re-sequencing, it is not simple to delete several occurrences if they are not consecutive or there are intermediate occurrences<br>
In your case, you want to delete the first three, it is easier<br>
<br>
mx snd300 "proc ='d69/1d69/1d69/1" copy = snd301<br>
<br>
but this must be analyzed case by case, there are no general rules <br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">regards</div>
<div class="moz-cite-prefix">ernesto spinak</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">El 3/3/2021 a las 15:08, Renate Morgenstern escribió:<br>
</div>
<blockquote type="cite">
<div>Hi Ernesto,</div>
<div><br>
</div>
<div>I am struggling with mx. </div>
<div>How do I only delete certain occurrences of a tag in a database? I have the following command, but then it deletes ALL the occurrences of tag 301:</div>
<div><br>
</div>
<div>mx snd300 "proc=(if v301*0.1='0' then 'd301[1]' fi,)" copy=snd301 now -all</div>
<div><br>
</div>
<div>When I add [1] after d301 I get the following error message:</div>
<div><br>
</div>
<div>fatal: [1]d301[1]d301[1]</div>
<div><br>
</div>
<div>I would like that it deletes occurrences 1-3 only.</div>
<div><br>
</div>
<div>Thanks in advance for your help.</div>
<div><br>
</div>
<div>Renate</div>
<div><span>
<pre></pre>
<pre>--
</pre>
<table width="100%" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td>Renate Morgenstern<br>
Tel.: +264 61 242124<br>
Cell: +264 81 2910284<br>
Fax: 088637518<br>
<div>10023, Windhoek, Namibia </div>
</td>
</tr>
</tbody>
</table>
</span></div>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a class="moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</div>
</div>
</div>
</body>
</html>