<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><font face="Comic Sans MS">Thanks Ernesto! I'm going to try it<br id="FontBreak"></font><br><br><div><span style="font-size:10pt">*****</span></div><div><b><font style="font-size:12pt" face="Comic Sans MS" size="3">Abel Rodrigues Monteiro</font></b></div><div><font face="Comic Sans MS">Mestre em Engenharia Documental</font></div><div><font face="Comic Sans MS">Contacto: 996 99 22</font></div><div><font face="Comic Sans MS">Sites:</font></div><div><ul><li><a href="http://biblioteca-online.net/bdados/" style="font-size:10pt" target="_blank">ABDATA - coloque sua biblioteca Online</a></li><li><a href="http://portal.biblioteca-online.net/php/index.php" style="font-size:10pt" target="_blank">Bibliotecas Online de C. Verde</a></li><li><a href="http://www.facebook.com/monteiroabel" style="font-size:10pt" target="_blank">Minha página no Facebook</a></li></ul><br><br></div><div>http://www.unicv.edu.cv/images/stories/Logo_UniCV.jpg<br></div><br><br><div><hr id="stopSpelling">Date: Thu, 2 Jan 2014 14:49:48 -0200<br>From: spinaker@adinet.com.uy<br>To: monteiroabel@hotmail.com; isis-users@iccisis.org<br>Subject: Re: [Isis-users] Global changes<br><br>
  
    
  
  
    <div class="ecxmoz-cite-prefix">Dear Abel<br>
      <br>
      before you do the changes, SAVE YOUR FILES, PLEASE !!!<br>
      <br>
      Ok, let's do the surgery<br>
      <br>
      mx   biblo  "proc='d200', '<200>', left(v200,size(v200)-1),
      '</200>' "  copy=biblo now -all tell=1000<br>
      <br>
      enjoy it<br>
      Ernesto Spinak<br>
      <br>
      <br>
      El 02/01/2014 14:27, Abel R. Monteiro escribió:<br>
    </div>
    <blockquote cite="mid:DUB112-W1251C81A59D1FBBAB6B5058CCCB0@phx.gbl">
      <style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}

.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}

--></style>
      <div dir="ltr"><font face="Comic Sans MS">Dear Ernesto,</font>
        <div><font face="Comic Sans MS">In the original database they
            put the subtitle in another field (title_remainder). So,
            what I did is to join these two fields and separed then by
            colon. </font></div>
        <div><font face="Comic Sans MS"><br>
          </font></div>
        <div><font face="Comic Sans MS">But is not all the records that
            have subtitle, and in this case it put the colon in the end
            of the title. It means that in case of a book with subtitle
            we get two colons. example:</font></div>
        <div><font face="Comic Sans MS"><br>
          </font></div>
        <div><font face="Comic Sans MS">Cabo Verde: economia e politica:</font></div>
        <div><font face="Comic Sans MS"><br>
          </font></div>
        <div><font face="Comic Sans MS">Best regards,</font></div>
        <div><br>
          <br>
          <div><span style="font-size:10pt;">*****</span></div>
          <div><b><font style="font-size:12pt;" face="Comic Sans MS" size="3">Abel Rodrigues Monteiro</font></b></div>
          <div>Date: Thu, 2 Jan 2014 14:13:13 -0200<br>
            From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a><br>
            To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:monteiroabel@hotmail.com">monteiroabel@hotmail.com</a>; <a class="ecxmoz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
            Subject: Re: [Isis-users] Global changes<br>
            <br>
            <div class="ecxmoz-cite-prefix">Abel<br>
              <br>
              one detail you missed<br>
              are you sure that the colon IS NOT present in any other
              part of this field?<br>
              so if I delete this char will not cause unexpected
              problems ?<br>
              <br>
              Ernesto<br>
              <br>
              <br>
              El 02/01/2014 14:06, Abel R. Monteiro escribió:<br>
            </div>
            <blockquote cite="mid:DUB112-W106F2BB2DE372188B816F5CCCB0@phx.gbl">
              <style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}

.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}


--></style>
              <div dir="ltr"><font face="Comic Sans MS">Dear Ernesto,</font>
                <div><font face="Comic Sans MS">Thank you for your
                    answer!</font></div>
                <div><font face="Comic Sans MS"><br>
                  </font></div>
                <div><font face="Comic Sans MS">a) V200 is not a
                    subfield.</font></div>
                <div><font face="Comic Sans MS">b)all the records ends
                    with colon (due of a concatenation when importing
                    from SQL)</font></div>
                <div><font face="Comic Sans MS"><br>
                  </font></div>
                <div><font face="Comic Sans MS">So, this the query I
                    used in SQL:</font></div>
                <div><font face="Comic Sans MS"><br>
                  </font></div>
                <div>
                  <p class="ecxMsoNormal">SELECT * , CONCAT( title,  ":
                    ", title_remainder ) </p>
                  <p class="ecxMsoNormal">FROM  `biblio` AS bb</p>
                  <p class="ecxMsoNormal">CROSS JOIN biblio_copy AS bc
                    ON bb.bibid = bc.bibid</p>
                  <p class="ecxMsoNormal">LIMIT 0 , 30</p>
                  <div><br>
                  </div>
                  <font face="Comic Sans MS">Best regards</font><br>
                  <br>
                  <div><span style="font-size:10pt;">*****</span></div>
                  <div><b><font style="font-size:12pt;" face="Comic Sans                          MS" size="3">Abel Rodrigues Monteiro</font></b></div>
                  <div><br>
                  </div>
                  <div>
                    <hr id="ecxstopSpelling">Date: Thu, 2 Jan 2014
                    12:54:10 -0200<br>
                    From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a><br>
                    To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
                    Subject: Re: [Isis-users] Global changes<br>
                    <br>
                    <div class="ecxmoz-cite-prefix">Dear Abel<br>
                      <br>
                      this is a very interesting challenge, because you
                      have to take care of some details, at least three<br>
                      <br>
                      1) is v200 a subfielded field?  for example: 
                      v200: <font color="#cc0000"><b>^a</b></font>Literatura
                      caboverdiana:<font color="#cc0000"><b>^b</b></font>something 
                      else<br>
                          so the colon (:) is not the last char of the
                      field, but of the subfield<br>
                      <br>
                      2) are you sure that ALL fields v200 end with the
                      colon, or could be some records without the colon
                      at the end<br>
                      <br>
                      3) is it possible that the the colon (:) is
                      correctly included into the main title part as
                      well as the end char?<br>
                          for example    v200  Titulo complejo<big><b>:</b></big>
                      otra parte de titulo<big><b>:</b></big> <br>
                         so you have to delete the LAST <font color="#333399"><big><b>:</b></big></font> but
                      no other : could be present in the string<br>
                      <br>
                      If we have a clear scenario, then we can use MX to
                      fix the problem<br>
                      <br>
                      Regards<br>
                      Ernesto Spinak<br>
                      <br>
                      <br>
                      El 02/01/2014 11:44, Abel R. Monteiro escribió:<br>
                    </div>
                    <blockquote cite="mid:DUB112-W4044224B41513BCB3B5557CCCB0@phx.gbl">
                      <style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}

.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}


--></style>
                      <div dir="ltr"><font face="Comic Sans MS">
                          <div>Olá Pessoal,</div>
                          <div>Em primeiro lugar queria desejar a todos
                            um feliz ano!</div>
                          <div><br>
                          </div>
                          <div>Será que alguém pode me ajudar? É o
                            seguinte: tenho uma base de dados em que no
                            campo titulo (etiqueta 200)  em todos os
                            registos existe : no fim do campo. Exemplo: </div>
                          <div>
                            <ul>
                              <li>Literatura caboverdiana<font color="#8c0095"><b>:</b></font></li>
                              <li>Quem matou Amilcar Cabral<font color="#8c0095"><b>:</b></font></li>
                            </ul>
                            <div>Como é que eu faço para eliminar esses
                              :? Existe alguma forma de fazer isso com
                              os utilirários MX etc?</div>
                          </div>
                          <div><br>
                          </div>
                          <div><font color="#008a17"><b><font size="4">"Nenhum

                                  ano será realmente novo se
                                  continuarmos a cometer os mesmos erros
                                  dos anos velhos."</font></b><font size="3"> <b>FELIZ 2014</b></font></font></div>
                          <div> </div>
                        </font><br>
                        <br>
                        <div><span style="font-size:10pt;">*****</span></div>
                        <div><b><font style="font-size:12pt;" face="Comic Sans MS" size="3">Abel
                              Rodrigues Monteiro</font></b></div>
                        <div><b><font style="font-size:12pt;" face="Comic Sans MS" size="3"><br>
                            </font></b></div>
                        <div><b><font style="font-size:12pt;" face="Comic Sans MS" size="3">**********************************************************************************************</font></b></div>
                        <div><b><font style="font-size:12pt;" face="Comic Sans MS" size="3"><br>
                            </font></b></div>
                        <div><b><font face="Comic Sans MS">
                              <div>Hello Dear Friends,</div>
                              <div>Firstly I wanted to wish everyone a
                                happy new year!</div>
                              <div><br>
                              </div>
                              <div>Can anyone help me? It is this: I
                                have a database where the title field
                                (tag 200) in all registers exist<font color="#ac193d" size="6">:</font> at
                                the end of the field. example:</div>
                              <div>
                                <ul>
                                  <li><b style="font-family:Calibri, sans-serif;font-size:12pt;"><font face="Comic Sans MS">
                                        <div style="display:inline !important;">Cape Verdean
                                          literature<font color="#ac193d">:</font></div>
                                      </font></b></li>
                                  <li><b style="font-family:Calibri, sans-serif;font-size:12pt;"><font face="Comic Sans MS">
                                        <div style="display:inline !important;">Who killed
                                          Amilcar Cabral<font color="#ac193d">:</font></div>
                                      </font></b></li>
                                </ul>
                              </div>
                              <div>How do I do to remove these<font style="font-size:24pt;" color="#ac193d" size="6">:</font> Is
                                there any way to do this with MX tools
                                etc?</div>
                              <div><br>
                              </div>
                              <div><font color="#008a17" size="4">"No
                                  really new year will be if we continue
                                  to make the same mistakes of years
                                  old." HAPPY 2014</font></div>
                              <div> </div>
                            </font></b></div>
                        <div><br>
                        </div>
                        <style><!--

--></style> </div>
                      <br>
                      <fieldset class="ecxmimeAttachmentHeader"></fieldset>
                      <br>
                      <pre>_______________________________________________
isis-users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>
To manage your own subscription options go to: <a class="ecxmoz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a>
Or contact Henk Rutten: <a class="ecxmoz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a>
</pre>
                    </blockquote>
                    <br>
                    <br>
                    <pre class="ecxmoz-signature">-- 
  .^.                                .^.
  ( )                                ( )
  ===                                ===
 =[=]================================[=]=
  | |  Ernesto Spinak                | |
  | |  <a class="ecxmoz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a>        | |
  | |  Montevideo, Uruguay           | |
  | |  tel/fax  (598) 2622-3352      | |
  | |  celular  (598) 99612238      | |
 =[=]================================[=]=
  ===                                ===
  ( )                                ( )
   V                                  V </pre>
                    <br>
                    _______________________________________________
                    isis-users mailing list <a class="ecxmoz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>
                    To manage your own subscription options go to: <a class="ecxmoz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a>
                    Or contact Henk Rutten: <a class="ecxmoz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a></div>
                </div>
              </div>
            </blockquote>
            <br>
            <br>
            <pre class="ecxmoz-signature">-- 
  .^.                                .^.
  ( )                                ( )
  ===                                ===
 =[=]================================[=]=
  | |  Ernesto Spinak                | |
  | |  <a class="ecxmoz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a>        | |
  | |  Montevideo, Uruguay           | |
  | |  tel/fax  (598) 2622-3352      | |
  | |  celular  (598) 99612238      | |
 =[=]================================[=]=
  ===                                ===
  ( )                                ( )
   V                                  V </pre>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    <br>
    <pre class="ecxmoz-signature">-- 
  .^.                                .^.
  ( )                                ( )
  ===                                ===
 =[=]================================[=]=
  | |  Ernesto Spinak                | |
  | |  <a class="ecxmoz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a>        | |
  | |  Montevideo, Uruguay           | |
  | |  tel/fax  (598) 2622-3352      | |
  | |  celular  (598) 99612238      | |
 =[=]================================[=]=
  ===                                ===
  ( )                                ( )
   V                                  V </pre></div>                                          </div></body>
</html>