5 messages · Tony Plate, Dirk Eddelbuettel, Peter Dalgaard +1 more
Dear all, I am struggling with the use of regular expression. I got
as.character(test$sample.id)
[1] "1.11" "10.11" "11.11" "113.31" "114.2" "114.3" "114.8" and need [1] "11" "11" "11" "31" "2" "3" "8" I.e. remove everything before the "." . TIA, Bernd
x <- scan("clipboard", what="")
Read 7 items
> x
[1] "1.11" "10.11" "11.11" "113.31" "114.2" "114.3" "114.8"
> gsub("[0-9]*\\.", "", x)
[1] "11" "11" "11" "31" "2" "3" "8"
>
Dear all, I am struggling with the use of regular expression. I got
as.character(test$sample.id)
[1] "1.11" "10.11" "11.11" "113.31" "114.2" "114.3" "114.8" and need [1] "11" "11" "11" "31" "2" "3" "8" I.e. remove everything before the "." . TIA, Bernd
______________________________________________ R-help at stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Bernd Weiss <bernd.weiss <at> uni-koeln.de> writes:
I am struggling with the use of regular expression. I got
as.character(test$sample.id)
[1] "1.11" "10.11" "11.11" "113.31" "114.2" "114.3" "114.8" and need [1] "11" "11" "11" "31" "2" "3" "8" I.e. remove everything before the "." .
Define the dot as the hard separator, and allow for multiple digits before it:
sample.id <- c("1.11", "10.11", "11.11", "113.31", "114.2", "114.3", "114.8")
gsub("^[0-9]*\.", "", sample.id)
[1] "11" "11" "11" "31" "2" "3" "8" Hope this helps, Dirk
Dirk Eddelbuettel <edd at debian.org> writes:
Bernd Weiss <bernd.weiss <at> uni-koeln.de> writes:
I am struggling with the use of regular expression. I got
as.character(test$sample.id)
[1] "1.11" "10.11" "11.11" "113.31" "114.2" "114.3" "114.8" and need [1] "11" "11" "11" "31" "2" "3" "8" I.e. remove everything before the "." .
Define the dot as the hard separator, and allow for multiple digits before it:
sample.id <- c("1.11", "10.11", "11.11", "113.31", "114.2", "114.3", "114.8")
gsub("^[0-9]*\.", "", sample.id)
[1] "11" "11" "11" "31" "2" "3" "8"
Or, more longwinded, but with less assumptions about what goes before the dot:
gsub("^.*\\.(.*)$","\\1",sample.id)
[1] "11" "11" "11" "31" "2" "3" "8" or,
gsub("^.*\\.([^.]*)$","\\1",sample.id)
[1] "11" "11" "11" "31" "2" "3" "8"
O__ ---- Peter Dalgaard ??ster Farimagsgade 5, Entr.B c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907
Dirk Eddelbuettel <edd at debian.org> writes:
Bernd Weiss <bernd.weiss <at> uni-koeln.de> writes:
I am struggling with the use of regular expression. I got
as.character(test$sample.id)
[1] "1.11" "10.11" "11.11" "113.31" "114.2" "114.3" "114.8" and need [1] "11" "11" "11" "31" "2" "3" "8" I.e. remove everything before the "." .
Define the dot as the hard separator, and allow for multiple digits before it:
sample.id <- c("1.11", "10.11", "11.11", "113.31", "114.2",
"114.3", "114.8") gsub("^[0-9]*\.", "", sample.id)
[1] "11" "11" "11" "31" "2" "3" "8"
Or, more longwinded, but with less assumptions about what goes before the dot:
gsub("^.*\\.(.*)$","\\1",sample.id)
[1] "11" "11" "11" "31" "2" "3" "8"
Wow, thanks a lot for all the valuable suggestions. Bernd