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