<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-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"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
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="moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:monteiroabel@hotmail.com">monteiroabel@hotmail.com</a>; <a class="moz-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 moz-do-not-send="true"
class="ecxmoz-txt-link-abbreviated"
href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a><br>
To: <a moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" 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="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a class="moz-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>
</body>
</html>