Convert dd/mm/yy and dd/mm/yyyy to Dates

by

You can use parse_date_time from lubridate:

some.dates <- c("23/11/12", "20/10/2012", "22/10/2012" ,"23/11/12")
parse_date_time(some.dates,c('dmy'))
[1] "2012-11-23 UTC" "2012-10-20 UTC" "2012-10-22 UTC" "2012-11-23 UTC"

But , Note that the order of format is important :

some.dates <- c("20/10/2012","23/11/12",  "22/10/2012" ,"23/11/12")
parse_date_time(some.dates,c('dmY','dmy'))

[1] "2012-10-20 UTC" "2012-11-23 UTC" "2012-10-22 UTC" "2012-11-23 UTC"

EDIT

Internally parse_date_time is using guess_formats (which I guess uses some regular expressions):

guess_formats(some.dates,c('dmy'))
       dmy        dmy        dmy        dmy 
"%d/%m/%Y" "%d/%m/%y" "%d/%m/%Y" "%d/%m/%y"

As mentioned in the comment you can use parse_date_time like this:

as.Date(dates, format = guess_formats(dates,c('dmy')))

More Related Contents:

  1. How do I deal with special characters like \^$.?*|+()[{ in my regex?
  2. How to calculate the number of occurrence of a given character in each row of a column of strings?
  3. Extracting a string between other two strings in R
  4. Extract info inside all parenthesis in R
  5. Replace single backslash in R
  6. Extract a substring according to a pattern
  7. Remove all special characters from a string in R?
  8. Regex group capture in R with multiple capture-groups
  9. Create new column in dataframe based on partial string matching other column
  10. Remove all text between two brackets
  11. R/regex with stringi/ICU: why is a ‘+’ considered a non-[:punct:] character?
  12. Escaped Periods In R Regular Expressions
  13. R dplyr: rename variables using string functions
  14. Why is this regex using lookbehinds invalid in R?
  15. Select rows from data.frame ending with a specific character string in R
  16. Use gsub remove all string before first white space in R
  17. Why can’t you use repetition quantifiers in zero-width look behind assertions?
  18. R split on delimiter (split) keep the delimiter (split)
  19. Splitting a string on the first space
  20. regex for preserving case pattern, capitalization
  21. Test for numeric elements in a character string
  22. Remove square brackets from a string vector
  23. Are there raw strings in R for regular expressions?
  24. Overlapping matches in R
  25. extract number after specific string
  26. Regex return file name, remove path and file extension
  27. Replace first occurrence of “:” but not second in R
  28. Extract last 4-digit number from a series in R using stringr
  29. Extracting text after last period in string [duplicate]
  30. How to prevent regmatches drop non matches?

Leave a Comment