<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" style="color: rgb(68, 68, 68);">PERFECT!!!!</font><span style="color: rgb(68, 68, 68); font-family: Calibri; line-height: 22px;"></span><div style="line-height: 22px; color: rgb(68, 68, 68); font-family: Calibri;"><font face="Comic Sans MS" style="line-height: normal;"><br style="line-height: 22px;"></font></div><div style="line-height: 22px; color: rgb(68, 68, 68); font-family: Calibri;"><font face="Comic Sans MS" style="line-height: normal;">Thank you Ernesto!!!!</font><font face="Comic Sans MS" style="line-height: normal;"><br style="line-height: 22px;"></font><br></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><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 15:22:27 -0200<br>From: spinaker@adinet.com.uy<br>To: monteiroabel@hotmail.com<br>Subject: Re: [Isis-users] Global changes<br><br>
<div class="ecxmoz-cite-prefix">Abel<br>
<br>
gotcha!!! this is was one of my first questions, namely the 2nd
question<br>
<i>2) are you sure that ALL fields v200 end with the colon, or
could be some records without the colon at the end</i><br>
<br>
then, you have to modify the script<br>
<br>
mx biblo "proc=if right(v200,1)=':' then 'd200',
'<200>', left(v200,size(v200)-1), '</200>' fi "
copy=biblo now -all tell=1000<br>
<br>
Ernesto<br>
<br>
<br>
El 02/01/2014 15:17, Abel R. Monteiro escribió:<br>
</div>
<blockquote cite="mid:DUB112-W47B879241653E86D45E828CCCB0@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">Sorry Ernesto,</font>
<div>When there is a subtitle the colon don't apear in the end.
An example:</div>
<div><br>
</div>
<div>When Have only the title I get:</div>
<div>
<ul>
<li><span style="font-size:12pt;">Quem matou Amilcar
Cabral:</span></li>
</ul>
<div>When have subtitle:</div>
</div>
<div>
<ul>
<li>Cabo Verde: economia e politica</li>
</ul>
<div><br>
</div>
</div>
<div>So if I use the command line you give me this erase the "l"
the end of the title And I'll get this Quem matou Amilcar
cabra</div>
<div><br>
</div>
<div>Best regards,</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 dir="ltr"><br>
<div>
<hr id="ecxstopSpelling">Date: Thu, 2 Jan 2014 14:49:48
-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">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>
</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>