Re: [R] substring if value starts with a character

Hi, Try:  dat <- read.table(text="A 1  R5000 2  R4800 3  R4700 4  3500 5  3800",sep="",header=TRUE,stringsAsFactors=FALSE)  dat$A <- as.numeric(gsub("[[:alpha:]]+","",dat$A)) A.K. On Monday, May 19, 2014 9:02 AM, Mat wrote: Hello togehter, i have a litte problem to convert a data.frame. My

Re: [R] substring if value starts with a character

Hi Mat, Try that: gsub("[A-Za-z]", "", df$A) This is a regular expression that looks for all characters (A to Z and a to z) and replaces it with nothing ("") You will need to convert the column to numeric after this operation. HTH, Ivan -- Ivan Calandra University of Franche-Comté Laboratoir

Re: [R] substring if value starts with a character

Hello, Try the following. dat <- read.table(text = " A 1 R5000 2 R4800 3 R4700 4 3500 5 3800 ", header = TRUE) dat dat2 <- dat dat2[] <- lapply(dat, function(x) sub("^[[:alpha:]]*(.*$)", "\\1", x)) dat2 Hope this helps, Rui Barradas Em 19-05-2014 14:00, Mat escreveu: Hello togehter,

[R] substring if value starts with a character

Hello togehter, i have a litte problem to convert a data.frame. My data.frame looks like this one A 1 R5000 2 R4800 3 R4700 4 3500 5 3800 I need now a command, which outputs all the numbers, without the character in front. The solution look like this one: A 1 5000 2 4800 3