how to split large numbers to groups in R

Question

I am having troubles to separate large numbers into groups. For example:

a<-"2009031930111"

what I would like to get it:

year<-2009
month<-03
day<-19

Thank you in advance.

Why not make it an actual date object? (`strptime(a, "%Y%m%d")`) — A5C1D2H2I1M1N2O1R2T1, Dec 17 '15 at 14:10
Possibly duplicate of http://stackoverflow.com/questions/11446499/r-programming-multiple-substr ? — jogo, Dec 17 '15 at 14:14

score 3 · Accepted Answer · answered Dec 17 '15 at 14:16

3

Using substr() you can do:

a<-"2009031930111"
substr(a, 1, 4)
substr(a, 5, 6)
substr(a, 7, 8)

eventually you want to convert: as.numeric(substr(...))

answered Dec 17 '15 at 14:16

jogo

score 3 · Answer 2 · answered Dec 17 '15 at 14:21

3

As @Ananda Mahto said you can convert it into date object and then using lubridate package separate its years, months and date

a<-"2009031930111"
x <- strptime(a, "%Y%m%d")
library(lubridate)
year(x)
# [1] 2009
month(x)
# [1] 3
day(x)
# [1] 19

answered Dec 17 '15 at 14:21

Ronak Shah

2 Answers2