[Isis-users] Fwd: Re: Global changes
spinaker
spinaker at adinet.com.uy
Thu Jan 2 18:40:20 CET 2014
-------- Mensaje original --------
Asunto: Re: [Isis-users] Global changes
Fecha: Thu, 02 Jan 2014 15:22:27 -0200
De: spinaker <spinaker at adinet.com.uy>
Para: Abel R. Monteiro <monteiroabel at hotmail.com>
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 <mailto:spinaker at adinet.com.uy>
> To: monteiroabel at hotmail.com <mailto:monteiroabel at hotmail.com>;
> isis-users at iccisis.org <mailto: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 <mailto:spinaker at adinet.com.uy>
> To: isis-users at iccisis.org <mailto: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:
> *^a*Literatura caboverdiana:*^b*something 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 <mailto: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 <mailto:hlrutten at xs4all.nl>
>
>
>
> --
> .^. .^.
> ( ) ( )
> === ===
> =[=]================================[=]=
> | | Ernesto Spinak | |
> | |spinaker at adinet.com.uy <mailto: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
> <mailto: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 <mailto:hlrutten at xs4all.nl>
>
>
>
> --
> .^. .^.
> ( ) ( )
> === ===
> =[=]================================[=]=
> | | Ernesto Spinak | |
> | |spinaker at adinet.com.uy <mailto:spinaker at adinet.com.uy> | |
> | | Montevideo, Uruguay | |
> | | tel/fax (598) 2622-3352 | |
> | | celular (598) 99612238 | |
> =[=]================================[=]=
> === ===
> ( ) ( )
> V V
>
>
>
> --
> .^. .^.
> ( ) ( )
> === ===
> =[=]================================[=]=
> | | Ernesto Spinak | |
> | |spinaker at adinet.com.uy <mailto: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/1ca426dd/attachment.html>
More information about the isis-users
mailing list