<html><head></head><body><div class="yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div>¡<font size="3">Excelente Ernesto!</font></div><div><font size="3">¡Muchas gracias!</font></div><div><font size="3">Un abrazo.</font></div><div><font size="3"><br></font></div><div><font size="3">Daniel Biset</font></div><div><br></div><div><br></div><div id="ydpa1047ff6yahoo_quoted_0819157784" class="ydpa1047ff6yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
El martes, 19 de febrero de 2019 3:26:34 p. m. GMT-3, spinaker <spinaker@adinet.com.uy> escribió:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpa1047ff6yiv3526611446"><div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix">Daniel</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix"><br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix">Para obtener la última ocurrencia de un
campo se indica con el atributo [LAST] (case sensitive)<br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix">En tu ejemplo sería v200[LAST]</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix">si quieres que solo aparezca el
subcampo (si existe) da lo mismo poner v200^u[LAST] o
v200[LAST]^u</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix"><br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix">saludos</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix">Ernesto Spinak<br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix"><br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix"><br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446moz-cite-prefix"><br clear="none">
</div>
<div class="ydpa1047ff6yiv3526611446yqt7566095317" id="ydpa1047ff6yiv3526611446yqtfd99883"><div class="ydpa1047ff6yiv3526611446moz-cite-prefix">El 19/02/2019 a las 13:43, daniel biset
escribió:<br clear="none">
</div>
<blockquote type="cite">
</blockquote></div></div><div class="ydpa1047ff6yiv3526611446yqt7566095317" id="ydpa1047ff6yiv3526611446yqtfd38363"></div><div><div class="ydpa1047ff6yiv3526611446yqt7566095317" id="ydpa1047ff6yiv3526611446yqtfd56927"><div class="ydpa1047ff6yiv3526611446ydpadbaf21yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;">Estimados/as:</div>
</div><div class="ydpa1047ff6yiv3526611446ydpadbaf21yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div class="ydpa1047ff6yiv3526611446yqt7566095317" id="ydpa1047ff6yiv3526611446yqtfd97697"> <span>
</span><p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><span>En
ABCD 1.5.1 m</span>e interesa obtener la última occ de un
campo/subcampo:</p>
<span>
</span><p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"> </p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">Un
registro donde el nocc v200^u es = a 3 (por ejemplo, pero el
nocc
varía de un registro a otro)</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"> </p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">En
un registro<span> </span>puede haber, por
ejemplo, 3 ocurrencias del v200^u: 20181230 - 20181231 -
20190331</p>
<div><span>
</span><p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><br clear="none">
</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">Primero
probé con:</p>
</div>
<span>
</span><p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">v200[nocc(v200)]</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">Resultado:</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><span style="font-size:13.5pt;color:red;">WXIS|executionerror|formatsyntax|nocc(v200)]
<br clear="none">
</span>WXIS|executionerror|formatsyntax|nocc(v200)] |</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"> </p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">Luego
con :</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">(if
iocc=nocc(v200) then ' ultimo 1 'v200^u, fi,)'<br />'
=
ningún resultado (pero si el nocc= 1, presenta esa única
occ)</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">If
iocc=nocc(v200) then ' ultimo 2 'v200^u, fi,'<br />' =
ningún
resultado</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">(if
iocc<nocc(v200) then ' ultimo 3 'v200^u, fi,)'<br
/>' =
ultimo 3 20181230 ultimo 3 20181231</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">(if
iocc<>nocc(v200) then ' ultimo 4 'v200^u, fi,)'<br
/>',
= ultimo 4 20181230 ultimo 4 20181231</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"> </p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">Recurro
a asignar el nocc a una variable s</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"> </p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><a shape="rect" class="ydpa1047ff6yiv3526611446moz-txt-link-freetext">s3:=(f(nocc(v200),2,0))</a>,
,</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;">v200[s3]</p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><span style="font-size:10.0pt;font-family:Georgia, serif;color:black;"> </span></p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><span style="font-size:10.0pt;font-family:Georgia, serif;color:black;">Aparece
el siguiente error:</span></p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><span style="font-size:10.0pt;font-family:Georgia, serif;color:black;"> </span></p>
<p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><span style="font-size:13.5pt;color:red;">WXIS|executionerror|format
syntax|s3] <br clear="none">
</span>WXIS|executionerror|format syntax|s3] |</p>
<div><span>
</span><p class="ydpa1047ff6yiv3526611446ydp7266e3adMsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height:normal;"><a shape="rect" name="_GoBack"></a> Agradezco
cualquier sugerencia al respecto.</p>
</div>
<div><span></span><br clear="none">
</div>
<div>Saludos</div>
</div><div><div class="ydpa1047ff6yiv3526611446yqt7566095317" id="ydpa1047ff6yiv3526611446yqtfd41320">Daniel H. Biset</div><br clear="none">
</div>
<span>
</span><br clear="none">
</div>
<br clear="none">
<fieldset class="ydpa1047ff6yiv3526611446mimeAttachmentHeader"></fieldset>
<pre class="ydpa1047ff6yiv3526611446moz-quote-pre">_______________________________________________
isis-users mailing list
<a shape="rect" class="ydpa1047ff6yiv3526611446moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org" rel="nofollow" target="_blank">isis-users@iccisis.org</a>
To manage your own subscription options go to: <a shape="rect" class="ydpa1047ff6yiv3526611446moz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users" rel="nofollow" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a>
Or contact Henk Rutten: <a shape="rect" class="ydpa1047ff6yiv3526611446moz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl" rel="nofollow" target="_blank">hlrutten@xs4all.nl</a>
</pre>
<p><br clear="none">
</p>
<pre class="ydpa1047ff6yiv3526611446moz-signature">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a shape="rect" class="ydpa1047ff6yiv3526611446moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy" rel="nofollow" target="_blank">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre><div class="ydpa1047ff6yiv3526611446yqt7566095317" id="ydpa1047ff6yiv3526611446yqtfd48179">
</div></div></div>_______________________________________________<br clear="none">isis-users mailing list<br clear="none"><a shape="rect" href="mailto:isis-users@iccisis.org" rel="nofollow" target="_blank">isis-users@iccisis.org</a><br clear="none">To manage your own subscription options go to: <a shape="rect" href="http://lists.iccisis.org/listinfo/isis-users" rel="nofollow" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a><br clear="none">Or contact Henk Rutten: <a shape="rect" href="mailto:hlrutten@xs4all.nl" rel="nofollow" target="_blank">hlrutten@xs4all.nl</a><div class="ydpa1047ff6yqt7566095317" id="ydpa1047ff6yqtfd08429"><br clear="none"></div></div>
</div>
</div></div></body></html>