<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">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="MsoNormal">SELECT * , CONCAT( title,
": ", title_remainder ) <o:p></o:p></p>
<p class="MsoNormal">FROM `biblio` AS bb<o:p></o:p></p>
<p class="MsoNormal">CROSS JOIN biblio_copy AS bc ON bb.bibid = bc.bibid<o:p></o:p></p>
<p class="MsoNormal">LIMIT 0 , 30<o:p></o:p></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="stopSpelling">Date: Thu, 2 Jan 2014 12:54:10 -0200<br>From: spinaker@adinet.com.uy<br>To: isis-users@iccisis.org<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
isis-users@iccisis.org
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten@xs4all.nl</div></div> </div></body>
</html>