PERFECT!!!!Thank you Ernesto!!!!
*****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 15:22:27 -0200
From: spinaker at adinet.com.uy
To: monteiroabel at hotmail.com
Subject: Re: [Isis-users] Global changes
Abel
gotcha!!! this is was one of my first questions, namely the 2nd
question
2) are you sure that ALL fields v200 end with the colon, or
could be some records without the colon at the end
then, you have to modify the script
mx biblo "proc=if right(v200,1)=':' then 'd200',
'<200>', left(v200,size(v200)-1), '</200>' fi "
copy=biblo now -all tell=1000
Ernesto
El 02/01/2014 15:17, Abel R. Monteiro escribió:
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
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
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | 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/b766935c/attachment.html>