cut a string after a dot in R

Question

All my column names start with

A.ABC.test1
A.ABC.test2
A.ABC.test3
A.ABC.test4
A.ABC.test5

I would like to keep only test1 , test2 ...

Any ideas?

`sub("......", "", x)` or better `sub(".*\\.", "", x)`, see https://stackoverflow.com/questions/22937618/reference-what-does-this-regex-mean and https://stackoverflow.com/questions/4736/learning-regular-expressions — jogo, Jun 22 '18 at 10:47

score 2 · Accepted Answer · answered Jun 22 '18 at 10:48

2

simply do: (by chance the same as @jogo commented)

colNames <- c("A.ABC.test1","A.ABC.test2","A.ABC.test3","A.ABC.test4","A.ABC.test5")
sub(".*\\.","",colNames)

#[1] "test1" "test2" "test3" "test4" "test5"

answered Jun 22 '18 at 10:48

Andre Elrico

10,956
6
50
69

score 0 · Answer 2 · answered Jun 22 '18 at 10:41

0

Maybe just gsub("A.ABC.", "", x)

answered Jun 22 '18 at 10:41

Lennyy

5,932
2
10
23

score 0 · Answer 3 · answered Jun 22 '18 at 10:45

0

x<-as.vector(colnames(df))
colnames(df)<-substr(x,7,11)

Where df is your data frame.

answered Jun 22 '18 at 10:45

rar

894
1
9
24

cut a string after a dot in R

3 Answers3