[ https://issues.apache.org/jira/browse/ARROW-14471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17446011#comment-17446011 ]
Dewey Dunnington commented on ARROW-14471: ------------------------------------------ lubridate does it by ignoring all non-alpha/numeric characters so it'll happily parse something like "01:::::23::::45" just the same as "012345" or anywhere inbetween. I forget the exact incantations for strptime, but we could provide a list of formats we're willing to consider for each of them or preprocess with a regex to reduce the number of formats we need to consider (i.e., {{gsub("[^A-Za-z0-9.]", " ")}}). If that sounds close enough for you I'm happy to make a PR! > [R] Implement lubridate's date/time parsing functions > ----------------------------------------------------- > > Key: ARROW-14471 > URL: https://issues.apache.org/jira/browse/ARROW-14471 > Project: Apache Arrow > Issue Type: Improvement > Components: R > Reporter: Nicola Crane > Assignee: Dewey Dunnington > Priority: Major > Fix For: 7.0.0 > > > Parse dates with year, month, and day components: > ymd() ydm() mdy() myd() dmy() dym() yq() ym() my() > > Parse date-times with year, month, and day, hour, minute, and second > components: > ymd_hms() ymd_hm() ymd_h() dmy_hms() dmy_hm() dmy_h() mdy_hms() mdy_hm() > mdy_h() ydm_hms() ydm_hm() ydm_h() > Parse periods with hour, minute, and second components: > ms() hm() hms() > -- This message was sent by Atlassian Jira (v8.20.1#820001)