[Isis-users] Global changes

[spinaker]

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: *^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 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/c90a575a/attachment.html>