Hi, all, I have a column like the following: ID TIME sub_001 0 sub_001 24 sub_002 0 sub_002 24 sub_003 0 sub_003 24 sub_004 0 sub_005 24 .. .. is there a way for me to just extract the numeric numbers from the ID column, omitting sub_? thanks, -- View this message in context: http://r.789695.n4.nabble.com/extract-number-from-a-mixture-of-character-and-number-tp4636659.html Sent from the R help mailing list archive at Nabble.com.
Jorge I Velez
2012-Jul-16 19:31 UTC
[R] extract number from a mixture of character and number
Hi, Check ?gsub and the examples there. Here is a piece of code to get you started:> s <- "sub_001" > gsub("sub_", "", s)[1] "001" HTH, Jorge.- On Mon, Jul 16, 2012 at 12:04 PM, york8866 <> wrote:> Hi, all, > > I have a column like the following: > ID TIME > sub_001 0 > sub_001 24 > sub_002 0 > sub_002 24 > sub_003 0 > sub_003 24 > sub_004 0 > sub_005 24 > .. > .. > > is there a way for me to just extract the numeric numbers from the ID > column, omitting sub_? > > thanks, > > > -- > View this message in context: > http://r.789695.n4.nabble.com/extract-number-from-a-mixture-of-character-and-number-tp4636659.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. >[[alternative HTML version deleted]]
Sarah Goslee
2012-Jul-16 19:36 UTC
[R] extract number from a mixture of character and number
Hi,
There are lots; the best choice depends on whether your ID values
always start with "sub_" or not, and you aren't clear. Here's
a
general case:
testdata <- c("sub_001", "sub_002", "sub_003")
gsub("[^0-9]", "", testdata)
You can use as.numeric() to convert them if desired.
If you use dput() to provide your data, someone might give you actual
working code.
Sarah
On Mon, Jul 16, 2012 at 12:04 PM, york8866 <yu_york at hotmail.com>
wrote:> Hi, all,
>
> I have a column like the following:
> ID TIME
> sub_001 0
> sub_001 24
> sub_002 0
> sub_002 24
> sub_003 0
> sub_003 24
> sub_004 0
> sub_005 24
> ..
> ..
>
> is there a way for me to just extract the numeric numbers from the ID
> column, omitting sub_?
>
> thanks,
>
>
--
Sarah Goslee
http://www.functionaldiversity.org