<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;} @font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:"Segoe UI Light"}
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:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
span.EstiloCorreioEletrnico17
{font-family:"Segoe UI Light",sans-serif;
color:windowtext}
.MsoChpDefault
{font-family:"Calibri",sans-serif}
@page WordSection1
{margin:70.85pt 3.0cm 70.85pt 3.0cm}
div.WordSection1
{}--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Jacinto,</p>
<p><br>
</p>
<p>Suppose you want to remove the last 3 characters of field v10. Write a proc for MX containing the following (e.g. named replace.prc):</p>
<p><br>
</p>
<p>'d10',</p>
<p>if p(v10) then '<10>', left(v10,size(v10)-3),'</10>' fi,<br>
</p>
<p><br>
</p>
<p>then run this proc using mx:</p>
<p><br>
</p>
<p>mx mydatabase proc=@replace.prc create=mydatab2 now -all</p>
<p><br>
</p>
<p>When all is OK, rename mydatab2 into mydatabase, reindex etc. (It might be a bit more complicated when subfields are present).</p>
<p><br>
</p>
<p>Piet de Keyser</p>
<p>UC Leuven-Limburg</p>
<p>Belgium<br>
</p>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>Van:</b> isis-users <isis-users-bounces+piet.dekeyser=ucll.be@iccisis.org> namens Jacinto Moura <moura.jacinto@gmail.com><br>
<b>Verzonden:</b> maandag 12 maart 2018 20:05<br>
<b>Aan:</b> 'isis-users'<br>
<b>Onderwerp:</b> [Isis-users] Update field</font>
<div> </div>
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Segoe UI Light",sans-serif" lang="EN-US">Dear All,
</span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI Light",sans-serif" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI Light",sans-serif" lang="EN-US">I would to like to update a field in all my ABCD database in certain condition. How should I do that? For example I must remove the last there characters from a text field.
</span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI Light",sans-serif" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI Light",sans-serif" lang="EN-US">Thanks,</span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI Light",sans-serif" lang="EN-US">Jacinto Moura
</span></p>
</div>
</div>
</div>
</body>
</html>