Removing character strings in date in R

Question

$ date "20141013T000000", "20141209T000000", "20150225T000000", "20141209T000000"

I have this "date" variable in R dataframe. I want to clean this variable and remove "T000000" such that "20141013T000000" shows only "20141013" so I can then convert my date variable into it's proper date format.

Thank you very much.

Possible duplicate of [Parsing ISO8601 date and time format in R](https://stackoverflow.com/questions/15838548/parsing-iso8601-date-and-time-format-in-r) — Kevin Arseneau, Dec 06 '17 at 07:40

score 2 · Answer 1 · answered Dec 06 '17 at 07:45

2

You don't need to remove that, you can just do the date-conversion directly and specify the existing format:

as.Date("20141013T000000", "%Y%m%dT000000")
# [1] "2014-10-13"

answered Dec 06 '17 at 07:45

talat

68,970
21
126
157

score 2 · Answer 2 · answered Dec 06 '17 at 09:19

2

Or a lubridate solution:

data <- "20141013T000000"
library(lubridate)
as_datetime(date)
#[1] "2014-10-13 UTC"

answered Dec 06 '17 at 09:19

J_F

9,956
2
31
55

Removing character strings in date in R

2 Answers2