Don't understand what this has to do with SQL, or why you're asking for SQL solutions in an R mailing list, but here are some R suggestions.

(abbreviating "COLUMN" with "C")

At 11:40 AM -0700 8/3/09, JoK LoQ wrote:
Hi,

Im trying to complete a list of jobs using SQL Querries and some "if else"
commands but im stucked in some steps. Could any of you give me some help?

-in COLUMN1 change the format 20JAN2000:00:00:00 to 20JAN2000 and exclude
every row that date is different from 20.

Assuming C1 contains character strings:
  C1 <- substring( C1, 1, 9)
  C1 <- C1[  substring(C1,1,2) == '20' ]


-extract the first character in COLUMN2 and creat COLUMN3 with that value
ex:
COL2,COL3
135,1
461,4
247,2

  C3 <- substring( C2, 1 ,1)
or
  C3 <- as.numeric( substring( C2, 1, 1) )


-in every row in which COL3=5, value in COLUMN4=value in COLUMN5

C4[ C3==5] <- C5[ C3==5]


-create COLUMN7 where if COLUMN6="north" then COLUMN7 value="N" else COLUMN7
value="X"

C7 <- ifelse( C6 == "north" , "N", "X")



Ill be grateful for any help, thnks
--
View this message in context: http://*www.*nabble.com/Some-SQL-Challenges-tp24795946p24795946.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help@r-project.org mailing list
https://*stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://*www.*R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


--
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA
925-423-1062

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to