<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<br>
<div class="moz-forward-container"><br>
<br>
-------- Mensaje original --------
<table class="moz-email-headers-table" cellpadding="0"
cellspacing="0" border="0">
<tbody>
<tr>
<th valign="BASELINE" align="RIGHT" nowrap="nowrap">Asunto:
</th>
<td>Re: [Isis-users] Global changes</td>
</tr>
<tr>
<th valign="BASELINE" align="RIGHT" nowrap="nowrap">Fecha: </th>
<td>Thu, 02 Jan 2014 15:22:27 -0200</td>
</tr>
<tr>
<th valign="BASELINE" align="RIGHT" nowrap="nowrap">De: </th>
<td>spinaker <a class="moz-txt-link-rfc2396E" href="mailto:spinaker@adinet.com.uy"><spinaker@adinet.com.uy></a></td>
</tr>
<tr>
<th valign="BASELINE" align="RIGHT" nowrap="nowrap">Para: </th>
<td>Abel R. Monteiro <a class="moz-txt-link-rfc2396E" href="mailto:monteiroabel@hotmail.com"><monteiroabel@hotmail.com></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-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"
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">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 moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a><br>
To: <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:monteiroabel@hotmail.com">monteiroabel@hotmail.com</a>;
<a moz-do-not-send="true"
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">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 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:monteiroabel@hotmail.com">monteiroabel@hotmail.com</a>;
<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">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="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>
</div>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a moz-do-not-send="true" 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>
<br>
</div>
<br>
</body>
</html>