How to remove part text from a column?

Question

I have a date value stored as a string in the following format: (Day_of_week Month Day, Year). I would like to remove the day of the week so the final format is: (Month Day, Year)

mydata <- data.frame(Date=c("Tuesday, September 19, 2017",
                            "Friday, April 20,2018"),
                     Date_Exp=c("September 19, 2017",
                                "April 20,2018"))

What are you trying to achieve? What is *day of the day*? Please show your attempt at solving it to clear out the issue. — Wiktor Stribiżew, Jun 22 '18 at 07:35
I want to remove day of the week that is given in my column "Date" ....Like Tuesday should be removed from "Tuesday, September 19, 2017" .. I want only "September 19, 2017" — Yogesh Kumar, Jun 22 '18 at 07:37

score 3 · Answer 1 · answered Jun 22 '18 at 07:42

3

as @Wiktor Stribiżew said.. ur task is clear but couldnt get the purpose. However this could solve ur problem:

format(as.Date(mydata$Date,format = "%A, %B %d, %Y"), format="%B %d %Y")
[1] "September 19 2017" "April 20 2018"

answered Jun 22 '18 at 07:42

Akshay

76
4

score 0 · Answer 2 · answered Jun 22 '18 at 07:40

0

Using gsub we can remove any number of characters followed by "," and space from the beginning of the date.

mydata$Date <- gsub("^[a-zA-z]+, ", "",mydata$Date)

answered Jun 22 '18 at 07:40

A. Suliman

12,923
5
24
37

score 0 · Answer 3 · edited Jun 22 '18 at 13:36

0

You could keep your dates as character strings and then use regex to remove the day of the week:

vec <- c("Tuesday, September 19, 2017", 
         "Friday, April 20,2018")

trimws(sub("^.*?,","",vec))

#[1] "September 19, 2017" "April 20,2018"

edited Jun 22 '18 at 13:36

divibisan

11,659
11
40
58

answered Jun 22 '18 at 07:54

Andre Elrico

10,956
6
50
69

How to remove part text from a column?

3 Answers3