Skip to content

updating values

3 messages · Daniel, Sean Davis, jeii@@@ry@@ m@iii@g oii gm@ii@com

Original
Daniel
# 
Hello all,I have a table with about 18000 rows, I need to UPDATE the strings
in the "name.x" column in each row by the strings from "name.y" given if
"name.x" is NA or " ". How can I do it?
Also I want to update values in other columns, but I think that will be the
same job.
Daniel
Sean Davis
#
On Thu, Jun 17, 2010 at 9:21 AM, Daniel <dmsilv at gmail.com> wrote:

            

      
      
      
    

        
You didn't really give us enough information to answer your question (what
database, what interface, etc.)  However, you'll probably want to use a SQL
update statement.  The syntax will vary slightly depending on database
engine and a little googling will probably get you the answer you need.

Sean

            

      
      
      
    

        

      
      
    

        

  
  


  


      

    

    

      
      

        


  

        

      jeii@@@ry@@ m@iii@g oii gm@ii@com
    

    

      
      #
    

  


  

      
Much like R-SIG-Finance, this isn't the correct forum or way to ask for help. 

Once is a mistake, twice isn't. Follow the posting guidelines if you want help. 

Jeff
Sent via BlackBerry from T-Mobile

-----Original Message-----
From: Daniel <dmsilv at gmail.com>
Date: Thu, 17 Jun 2010 10:21:48 
To: <r-sig-db at stat.math.ethz.ch>
Subject: [R-sig-DB] updating values

Hello all,I have a table with about 18000 rows, I need to UPDATE the strings
in the "name.x" column in each row by the strings from "name.y" given if
"name.x" is NA or " ". How can I do it?
Also I want to update values in other columns, but I think that will be the
same job.
Daniel