<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 bgcolor="#FFFFFF" text="#000000">
<div>Great, it works!!!<br>
<br>
so, what we need now is a function to clean a string of all
non-alphanumeric elements, i.e. spaces, typographic characteres,
etc.<br>
in this way you can create keys for FRBR independently of the
punctuation used in cataloging (isbd or other)<br>
<br>
ernesto spinak<br>
<br>
<br>
<br>
El 03/04/2016 a las 16:14, Piet De Keyser escribió:<br>
</div>
<blockquote type="cite">
<p>Yes, Guida, this works! That is the one we need! You keep
surprising us the good way. My mistake was I tried to construct
it as an end validation for a certain worksheet, and not for
general.</p>
<p><br>
</p>
<p>Piet<br>
</p>
<p><br>
</p>
<div style="color:rgb(33,33,33)">
<div dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>Van:</b>
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">isis-users@iccisis.org</a><br>
<b>Onderwerp:</b> Re: [Isis-users] ABCD and automatic field
update</font>
<div> </div>
</div>
<div>
<div dir="ltr">Update database definitions -> Record
validation -> End format -> General
<div><br>
</div>
<div>From the fields menu, select one field and build a
format. The string produced by the format will be stored
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,
Piet De Keyser <span dir="ltr">
<<a href="mailto:piet.dekeyser@ucll.be" target="_blank">piet.dekeyser@ucll.be</a>></span>
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
end format should be possible too. But if that is
the case, we need no special mechanism to replace
the spaces, since a replace command could do this
(plus: punctuation should also be stripped from our
"key").</p>
<p><br>
</p>
<p>You know, this is what we had in Weblis 10 years
ago: you could add many things (including content
from other databases) while saving. I know ABCD is
much more advanced compared with Weblis, but they
had some nice thing too, e.g. this one plus a very
good layout for thesauri. Maybe you and Guilda could
get the code from them for that too (in fact it is
open source software, although the source can only
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"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>Van:</b>
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>>
namens spinaker <<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">isis-users@iccisis.org</a><br>
<b>Onderwerp:</b> Re: [Isis-users] ABCD and
automatic field update</font>
<div> </div>
</div>
<div>
<div>Dear Piet<br>
<br>
As far as I know (Guilda should confirm) this is
a pending issue for a long time,<br>
this kind of feature should be implemented in<br>
Record Validation<br>
* End format<br>
where the format should include a PROC( )<br>
<br>
I think the reason this feature is pending is
because nobody has requested it before
<br>
<br>
If you want this kind of function (I imagine you
need it for FRBR indexation), we also need a
function to clean the string from
non-alphanumeric chars in order to generate
clean and compact unique keys<br>
<br>
Regards<br>
Ernesto Spinak<br>
<br>
<br>
<br>
<br>
El 02/04/2016 a las 11:52, Piet De Keyser
escribió:<br>
</div>
<blockquote type="cite">
<p>Dear friends,</p>
<p><br>
</p>
<p>Who knows a way to automatically add content
to a field in ABCD while saving a record. I
know it is possible to add the name and the
operator plus the data, to add increment the
control number and a few other things, but I
would need in e.g. a local field the processed
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>
-> this field would be automatically
added:<br>
<br>
v991^aBEATIFULAFRICASMITHJOHN<br>
<br>
Piet de Keyser<br>
(Belgium, although: who still dares to say
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>
<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>
</div>
</div>
<br>
_______________________________________________<br>
isis-users mailing list<br>
<a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
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>
Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl" target="_blank">hlrutten@xs4all.nl</a><br>
<br>
</blockquote>
</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>