<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">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></div><div>Date: Thu, 2 Jan 2014 14:13:13 -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">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></body>
</html>