Manipulate the string data in R?

Asked Jan 28 '20 at 12:45

Active Jan 28 '20 at 12:45

Viewed 27 times

I have a data set something like this, B column is character:

df <- tribble(
  ~A, ~B,
  "902640", "2007-12-09 14:52:21.000"
)

I want to have it something like this and B column should be the date:

df <- tribble(
  ~A, ~B,
  "902640", "2007-12-09"
)

How can I do this?

asked Jan 28 '20 at 12:45

datazang

`gsub("(.*)( )(.*)", "\\1", df$B)` – Allan Cameron Jan 28 '20 at 12:48
How to keep the first column? @AllanCameron – datazang Jan 28 '20 at 12:51
1

`df$B <- gsub("(.*)( )(.*)", "\\1", df$B)`. Now `df` will have the correct value – Allan Cameron Jan 28 '20 at 12:55

0 Answers0