<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>