<div dir="ltr">I can build an option in end format for cleanning the fields. Is this the output: <em style="color:rgb(33,33,33)">AscencioGuildaElartedeprogramarintroduccionejemplos&practicas2009 ? </em> No spaces between words? <br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 5, 2016 at 10:45 AM, spinaker <span dir="ltr"><<a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Piet<br>
<br>
the replace command could be a solution but very cumbersome<br>
let's say as an example<br>
<br>
s1:=s(v100,v245^a,v300^c)<br>
<br>
s1:= replace( replace( replace(s1,' ',''), ';',''),':','') ... etc
for all the non alphanumeric chars)<br>
<br>
I don't know if PFT would accept a recursive function with more
than almost 100 recursions<br>
<br>
Regards<br>
Ernesto<br>
<br>
<br>
El 05/04/2016 a las 11:03, Piet De Keyser escribió:<br>
</div>
<blockquote type="cite">
<p>Ernesto,</p>
<p><br>
</p>
<p>Yes, this would be the case (maybe best in uppercase). But I
don't think you need a new function for this because you could
use a set of replace commands in the format?</p>
<p><br>
</p>
<p>Piet<br>
</p>
<div style="color:rgb(33,33,33)">
<hr style="display:inline-block;width:98%">
<div dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>Van:</b>
Ernesto Spinak <a href="mailto:spinaker@vera.com.uy" target="_blank"><spinaker@vera.com.uy></a><br>
<b>Verzonden:</b> dinsdag 5 april 2016 13:48<br>
<b>Aan:</b> Guilda Ascencio<br>
<b>CC:</b> Piet De Keyser; <a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
<b>Onderwerp:</b> Re: [Isis-users] ABCD and automatic field
update</font>
<div> </div>
</div>
<div>
<div>Guilda<br>
</div>
<div><br>
</div>
<div>The idea of cleaning is something like the following
example<br>
</div>
<div><br>
</div>
<div>let's get a string made up of a combination of fields:
s(v100,v245^a,v300^c)<br>
</div>
<div><br>
</div>
<div> <<<em>Ascencio, Guilda, El arte de programar:
introducción; ejemplos & prácticas.[2009]>></em><br>
</div>
<div><br>
</div>
<div>then the clean function will return <<<em>AscencioGuildaElartedeprogramarintroduccionejemplos&practicas2009>></em><br>
</div>
<div><br>
</div>
<div>this string will be indexed with FRBR objective<br>
</div>
<div><br>
</div>
<div>Piet, is it correct?<br>
</div>
<div><br>
</div>
<div>Regards<br>
</div>
<div>Ernesto<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>----- Mensaje original -----<br>
De: Guilda Ascencio <a href="mailto:guildaa@gmail.com" target="_blank"><guildaa@gmail.com></a><br>
Para: spinaker <a href="mailto:spinaker@adinet.com.uy" target="_blank"><spinaker@adinet.com.uy></a><br>
CC: Piet De Keyser <a href="mailto:piet.dekeyser@ucll.be" target="_blank"><piet.dekeyser@ucll.be></a>,
<a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
Enviado: Tue, 05 Apr 2016 07:58:29 -0300 (UYT)<br>
Asunto: Re: [Isis-users] ABCD and automatic field update<br>
</div>
<div><br>
</div>
<div dir="ltr">Piet: The end format is intended to work also
with specific worksheet, so have to fix that.
<div><br>
</div>
<div>Ernesto: What is needed for the clean function? A list
of tags? All non alphabetic characters are to be removed?
<div><br>
</div>
<div>Regards </div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sun, Apr 3, 2016 at 2:23 PM,
spinaker <span dir="ltr">
<<a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div>Great, it works!!!<br>
<div><br>
</div>
<br>
so, what we need now is a function to clean a string
of all<br>
non-alphanumeric elements, i.e. spaces, typographic
characteres,<br>
etc.<br>
<div><br>
</div>
in this way you can create keys for FRBR
independently of the<br>
punctuation used in cataloging (isbd or other)<br>
<div><br>
</div>
<br>
ernesto spinak<br>
<div><br>
</div>
<br>
<div><br>
</div>
<br>
El 03/04/2016 a las 16:14, Piet De Keyser escribió:<br>
</div>
<blockquote>
<p>Yes, Guida, this works! That is the one we need!
You keep<br>
surprising us the good way. My mistake was I tried
to construct<br>
it as an end validation for a certain worksheet,
and not for<br>
general.</p>
<p><br>
</p>
<p>Piet<br>
</p>
<p><br>
</p>
<div style="color:rgb(33,33,33)">
<div dir="ltr"><span face="Calibri, sans-serif" color="#000000" style="font-size:11pt;color:#000000;font-family:Calibri,sans-serif"><b>Van:</b><br>
Guilda Ascencio <a href="mailto:guildaa@gmail.com" target="_blank"><guildaa@gmail.com></a><br>
<b>Verzonden:</b> zondag 3 april 2016 18:03<br>
<b>Aan:</b> Piet De Keyser<br>
<b>CC:</b> spinaker; <a href="mailto:isis-users@iccisis.org" target="_blank"></a><a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
<b>Onderwerp:</b> Re: [Isis-users] ABCD and
automatic field<br>
update</span>
<div> </div>
</div>
<div>
<div dir="ltr">Update database definitions ->
Record<br>
validation -> End format -> General<br>
<div><br>
</div>
<div>From the fields menu, select one field
and build a<br>
format. The string produced by the format
will be stored<br>
in the field selected (if the field is
empty)</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Apr 2, 2016
at 1:34 PM,<br>
Piet De Keyser <span dir="ltr"><br>
<<a href="mailto:piet.dekeyser@ucll.be" target="_blank">piet.dekeyser@ucll.be</a>></span><br>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" style="font-size:12pt;color:#000000;background-color:#ffffff;font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Dear Ernesto,</p>
<p><br>
</p>
<p>Thank you for your fast answer. Yes,
a proc ind the<br>
end format should be possible too. But
if that is<br>
the case, we need no special mechanism
to replace<br>
the spaces, since a replace command
could do this<br>
(plus: punctuation should also be
stripped from our<br>
"key").</p>
<p><br>
</p>
<p>You know, this is what we had in
Weblis 10 years<br>
ago: you could add many things
(including content<br>
from other databases) while saving. I
know ABCD is<br>
much more advanced compared with
Weblis, but they<br>
had some nice thing too, e.g. this one
plus a very<br>
good layout for thesauri. Maybe you
and Guilda could<br>
get the code from them for that too
(in fact it is<br>
open source software, although the
source can only<br>
be optained from Unesco).</p>
<p><br>
</p>
<p><br>
</p>
<p>Piet<br>
</p>
<p><br>
</p>
<p><br>
</p>
<div style="color:rgb(33,33,33)">
<hr style="display:inline-block;width:98%">
<div dir="ltr"><span face="Calibri,
sans-serif" color="#000000" style="font-size:11pt;color:#000000;font-family:Calibri,sans-serif"><b>Van:</b><br>
isis-users
<isis-users-bounces+piet.dekeyser=<a href="mailto:ucll.be@iccisis.org" target="_blank"></a><a href="mailto:ucll.be@iccisis.org" target="_blank">ucll.be@iccisis.org</a>><br>
namens spinaker <<a href="mailto:spinaker@adinet.com.uy" target="_blank"></a><a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a>><br>
<b>Verzonden:</b> zaterdag 2 april
2016 17:15<br>
<b>Aan:</b><a href="mailto:isis-users@iccisis.org" target="_blank"></a><a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
<b>Onderwerp:</b> Re: [Isis-users]
ABCD and<br>
automatic field update</span>
<div> </div>
</div>
<div>
<div>Dear Piet<br>
<div><br>
</div>
<br>
As far as I know (Guilda should
confirm) this is<br>
a pending issue for a long time,<br>
<div><br>
</div>
this kind of feature should be
implemented in<br>
<div><br>
</div>
Record Validation<br>
<div><br>
</div>
* End format<br>
<div><br>
</div>
where the format should include
a PROC( )<br>
<div><br>
</div>
<br>
I think the reason this feature is
pending is<br>
because nobody has requested it
before<br>
<br>
<div><br>
</div>
<br>
If you want this kind of function
(I imagine you<br>
need it for FRBR indexation), we
also need a<br>
function to clean the string from<br>
non-alphanumeric chars in order to
generate<br>
clean and compact unique keys<br>
<div><br>
</div>
<br>
Regards<br>
<div><br>
</div>
Ernesto Spinak<br>
<div><br>
</div>
<br>
<div><br>
</div>
<br>
<div><br>
</div>
El 02/04/2016 a las 11:52, Piet De
Keyser<br>
escribió:<br>
</div>
<blockquote>
<p>Dear friends,</p>
<p><br>
</p>
<p>Who knows a way to
automatically add content<br>
to a field in ABCD while saving
a record. I<br>
know it is possible to add the
name and the<br>
operator plus the data, to add
increment the<br>
control number and a few other
things, but I<br>
would need in e.g. a local field
the processed<br>
content of some other fields,
e.g.</p>
<p><br>
</p>
<p>-> these fields are keyed
in:</p>
<p><br>
</p>
<p>v100^aSmith, John<br>
</p>
<p>v245^aBeautiful Africa<br>
</p>
<div style="color:rgb(33,33,33)">
<div><br>
<div><br>
</div>
-> this field would be
automatically<br>
added:<br>
<div><br>
</div>
<br>
v991^aBEATIFULAFRICASMITHJOHN<br>
<div><br>
</div>
<br>
Piet de Keyser<br>
<div><br>
</div>
(Belgium, although: who still
dares to say<br>
he lives in Belgium?....)<br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
isis-users mailing list
<a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a>
To manage your own subscription options go to: <a href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a>
Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl" target="_blank">hlrutten@xs4all.nl</a>
</pre>
</blockquote>
<br>
<div><br>
</div>
<pre>--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</div>
</div>
</div>
<br>
<div><br>
</div>
_______________________________________________<br>
<div><br>
</div>
isis-users mailing list<br>
<a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
<div><br>
</div>
To manage your own subscription options go
to: <a href="http://lists.iccisis.org/listinfo/isis-users" rel="noreferrer" target="_blank">
</a><a href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a><br>
<div><br>
</div>
Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl" target="_blank"></a><a href="mailto:hlrutten@xs4all.nl" target="_blank">hlrutten@xs4all.nl</a><br>
<div><br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
<br>
<div><br>
</div>
<pre>--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</div>
</blockquote>
</div>
<br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</blockquote>
<br>
<br>
<pre cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</div>
</blockquote></div><br></div>