Hi, 

 

When I use your code i get this :

 

>dat<-data.frame(test=c("abc","cdf","dabc"))

>d<-subset(dat,grepl(test,"abc"))

>d

Warning message:

In grepl(test, "abc") :

  argument 'pattern' has length > 1 and only the first element will be used

> d

  test

1  abc

2  cdf

3 dabc

 

I can't seem to make it work. Also how would i use the grepl() to select only those that are not like i.e. »GP«?

 

Thanks, m

 

 

From: Steven Kennedy [mailto:stevenkennedy2263@gmail.com] 
Sent: Monday, May 02, 2011 11:30 AM
To: Matevž Pavlič
Cc: r-help@r-project.org
Subject: Re: [R] subseting data

 

You can use grepl:

> dat<-data.frame(test=c("abc","cdf","dabc"))
> d<-subset(dat,grepl(test,"abc"))
> d
  test
1  abc
3 dabc




On Mon, May 2, 2011 at 7:03 PM, Matevž Pavlič <matevz.pavlic@gi-zrmk.si> wrote:

Hi,



Is it possible (i am sure it is)  to subset data from a data.frame on the basis of SQL >LIKE< operator. I.e., i would like to subset a data where only values which contains a string >GP< would be used?



Example:



Gp<-subset(DF, DF$USCS like >GP<)



This like of course is not working,



Thanks, m


       [[alternative HTML version deleted]]

______________________________________________
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.

 


	[[alternative HTML version deleted]]

