Separate a column without separators

Question

I have a dataset with a column that consists of a code and a number and I am trying to separate that column just to get the code.

df <- data.frame(code=rep(c('2d01', '2m04', '3C06', 'CrD05'), each=10),
                 pos=rep(c(3, 7,2,4), times=20))
df<-extract(df,code,into = c("code","number"),
            "(.{2})(.{2})")

I tried this but I have a code with a different number of characters (CrD05) so it doesn't work. Is there a way to separate the last 2 numbers and keep the rest?

[This is a similar question with nice answers.](https://stackoverflow.com/questions/15897236/extract-the-first-or-last-n-characters-of-a-string) — MSD20, Nov 16 '21 at 14:01

Bastian Andres · Accepted Answer · 2021-11-16T15:11:27.980

0

Using gsub to extract the last two characters

df$code2 = gsub("\\d{2}$", "", df$code)

edited Nov 16 '21 at 15:11

answered Nov 16 '21 at 13:46

Bastian Andres

198
1
8

Thanks for the answer but I was looking to remove the last 2 numbers so I can keep the code – Gonzalo de Quesada Nov 16 '21 at 13:51
1

I misunderstood, I edit my answer – Bastian Andres Nov 16 '21 at 15:12
If I also wanted to remove the letter how could I code it? – Gonzalo de Quesada Nov 17 '21 at 13:17

Separate a column without separators

1 Answers1