Re: [R] Differentiate alphanumeric vs numeric strings

From: Farrel Buchinsky <fjbuch_at_gmail.com>
Date: Fri, 25 Apr 2008 16:27:31 -0400

This is fantastic.
As a future note to myself and to others who may stumble upon this: further documentation for all one's heart could desire is in the base help system at.

Regular Expressions as used in R - regexp

Pattern Matching and Replacement - grep

Split the Elements of a Character Vector - strsplit

The following worked in my situation:
channel2007<-odbcConnectAccess("filename for 2007 data") tables <-sqlTables(channel2007)[,3]
tables <-grep("[[:digit:]]",tables,value=TRUE) all2007 <-sqlFetch(channel2007, tables[1]) for (f in tables[-1]) all2007<-rbind(all2007, sqlFetch(channel2007, f))

Thanks for your help

On Thu, Apr 24, 2008 at 11:34 PM, jim holtman <jholtman_at_gmail.com> wrote:
> The following will return the indices or the values of character
> strings that are all numeric:
>
> > x <- c("12345", "123AS23", "A123", "398457")
> > grep("^[[:digit:]]*$", x) # index
> [1] 1 4
> > grep("^[[:digit:]]*$", x, value=TRUE) # values
> [1] "12345" "398457"
>
>
>
> >
>
>
>
> On Thu, Apr 24, 2008 at 10:39 PM, Farrel Buchinsky <fjbuch_at_gmail.com> wrote:
> > I have a bunch of tables in a Microsoft Access database. An updated database
> > is sent to me every week containing a new table. I know that is inefficient
> > and weird but welcome to my life. I want to read the tables whose names are
> > something such as "040207" but not the ones that have alphanumeric names
> > such as "everyone". Using RODBC I am easily able to create a character
> > vector of the names of the tables. Is there a function that can
> > differentiate values consisting only of digits (numerics) as opposed to ones
> > that contain letters (and perhaps digts as well)? I am sure there is. What
> > is it and where should I have found it?
> >
> > --
> > Farrel Buchinsky
> > GrandCentral Tel: (412) 567-7870
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help_at_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.
> >
>
>
>
> --
> Jim Holtman
> Cincinnati, OH
> +1 513 646 9390
>
> What is the problem you are trying to solve?
>

-- 
Farrel Buchinsky
GrandCentral Tel: (412) 567-7870

______________________________________________
R-help_at_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.
Received on Fri 25 Apr 2008 - 20:30:22 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 25 Apr 2008 - 23:30:31 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive