[Isis-users] Global changes

[Abel R. Monteiro]

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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20140102/af4b0cf6/attachment.html>