[Isis-users] Global changes
spinaker
spinaker at adinet.com.uy
Thu Jan 2 17:49:48 CET 2014
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 <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 | |
| | 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/c3f36ae3/attachment.html>
More information about the isis-users
mailing list