[Isis-users] Global changes
Abel R. Monteiro
monteiroabel at hotmail.com
Thu Jan 2 17:27:07 CET 2014
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 MonteiroDate: 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20140102/d01e21ae/attachment.html>
More information about the isis-users
mailing list