[Isis-users] Global changes
Abel R. Monteiro
monteiroabel at hotmail.com
Thu Jan 2 18:17:11 CET 2014
Sorry Ernesto,When there is a subtitle the colon don't apear in the end. An example:
When Have only the title I get:Quem matou Amilcar Cabral:When have subtitle:Cabo Verde: economia e politica
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
Best regards,
*****Abel Rodrigues Monteiro
From: monteiroabel at hotmail.com
To: spinaker at adinet.com.uy; isis-users at iccisis.org
Subject: RE: [Isis-users] Global changes
Date: Thu, 2 Jan 2014 20:54:29 +0400
Thanks Ernesto! I'm going to try it
*****Abel Rodrigues MonteiroMestre em Engenharia DocumentalContacto: 996 99 22Sites:ABDATA - coloque sua biblioteca OnlineBibliotecas Online de C. VerdeMinha página no Facebook
http://www.unicv.edu.cv/images/stories/Logo_UniCV.jpg
Date: Thu, 2 Jan 2014 14:49:48 -0200
From: spinaker at adinet.com.uy
To: monteiroabel at hotmail.com; isis-users at iccisis.org
Subject: Re: [Isis-users] Global changes
Dear Abel
before you do the changes, SAVE YOUR FILES, PLEASE !!!
Ok, let's do the surgery
mx biblo "proc='d200', '<200>', left(v200,size(v200)-1),
'</200>' " copy=biblo now -all tell=1000
enjoy it
Ernesto Spinak
El 02/01/2014 14:27, Abel R. Monteiro escribió:
Dear Ernesto,
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.
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:
Cabo Verde: economia e politica:
Best regards,
*****
Abel Rodrigues Monteiro
Date: Thu, 2 Jan 2014 14:13:13 -0200
From: spinaker at adinet.com.uy
To: monteiroabel at hotmail.com; isis-users at iccisis.org
Subject: Re: [Isis-users] Global changes
Abel
one detail you missed
are you sure that the colon IS NOT present in any other
part of this field?
so if I delete this char will not cause unexpected
problems ?
Ernesto
El 02/01/2014 14:06, Abel R. Monteiro escribió:
Dear Ernesto,
Thank you for your
answer!
a) V200 is not a
subfield.
b)all the records ends
with colon (due of a concatenation when importing
from SQL)
So, this the query I
used in SQL:
SELECT * , CONCAT( title, ":
", title_remainder )
FROM `biblio` AS bb
CROSS JOIN biblio_copy AS bc
ON bb.bibid = bc.bibid
LIMIT 0 , 30
Best regards
*****
Abel Rodrigues Monteiro
Date: Thu, 2 Jan 2014
12:54:10 -0200
From: spinaker at adinet.com.uy
To: isis-users at iccisis.org
Subject: Re: [Isis-users] Global changes
Dear Abel
this is a very interesting challenge, because you
have to take care of some details, at least three
1) is v200 a subfielded field? for example:
v200: ^aLiteratura
caboverdiana:^bsomething
else
so the colon (:) is not the last char of the
field, but of the subfield
2) are you sure that ALL fields v200 end with the
colon, or could be some records without the colon
at the end
3) is it possible that the the colon (:) is
correctly included into the main title part as
well as the end char?
for example v200 Titulo complejo:
otra parte de titulo:
so you have to delete the LAST : but
no other : could be present in the string
If we have a clear scenario, then we can use MX to
fix the problem
Regards
Ernesto Spinak
El 02/01/2014 11:44, Abel R. Monteiro escribió:
Olá Pessoal,
Em primeiro lugar queria desejar a todos
um feliz ano!
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:
Literatura caboverdiana:
Quem matou Amilcar Cabral:
Como é que eu faço para eliminar esses
:? Existe alguma forma de fazer isso com
os utilirários MX etc?
"Nenhum
ano será realmente novo se
continuarmos a cometer os mesmos erros
dos anos velhos." FELIZ 2014
*****
Abel
Rodrigues Monteiro
**********************************************************************************************
Hello Dear Friends,
Firstly I wanted to wish everyone a
happy new year!
Can anyone help me? It is this: I
have a database where the title field
(tag 200) in all registers exist: at
the end of the field. example:
Cape Verdean
literature:
Who killed
Amilcar Cabral:
How do I do to remove these: Is
there any way to do this with MX tools
etc?
"No
really new year will be if we continue
to make the same mistakes of years
old." HAPPY 2014
_______________________________________________
isis-users mailing list
isis-users at iccisis.org
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | spinaker at adinet.com.uy | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V
_______________________________________________
isis-users mailing list isis-users at iccisis.org
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | spinaker at adinet.com.uy | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | spinaker at adinet.com.uy | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20140102/329dfd36/attachment.html>
More information about the isis-users
mailing list