Remove/Replace/Extract Dates

Description

Remove/replace/extract dates from a string in the form of (1) XX/XX/XXXX, XX/XX/XX, XX-XX-XXXX, XX-XX-XX, XX.XX.XXXX, or XX.XX.XX OR (2) March XX, XXXX or Mar XX, XXXX OR (3) both forms.

Usage

1
2
3
4
5
6
7
rm_date(text.var, trim = !extract, clean = TRUE, pattern = "@rm_date",
  replacement = "", extract = FALSE,
  dictionary = getOption("regex.library"), ...)

ex_date(text.var, trim = !extract, clean = TRUE, pattern = "@rm_date",
  replacement = "", extract = TRUE,
  dictionary = getOption("regex.library"), ...)

Arguments

text.var

The text variable.

trim

logical. If TRUE removes leading and trailing white spaces.

clean

trim logical. If TRUE extra white spaces and escaped character will be removed.

pattern

A character string containing a regular expression (or character string for fixed = TRUE) to be matched in the given character vector (see Details for additional information). Default, @rm_date uses the rm_date regex from the regular expression dictionary from the dictionary argument.

replacement

Replacement for matched pattern.

extract

logical. If TRUE the dates are extracted into a list of vectors.

dictionary

A dictionary of canned regular expressions to search within if pattern begins with "@rm_".

...

Other arguments passed to gsub.

Details

The default regular expression used by rm_date finds numeric representations not word/abbreviations. This means that "June 13, 2002" is not matched. This behavior can be altered (to include month names/abbreviations) by using a secondary regular expression from the regex_usa data (or other dictionary) via (pattern = "@rm_date2", pattern = "@rm_date3", or pattern = "@rm_date4"). See Examples for example usage.

Value

Returns a character string with dates removed.

See Also

gsub, stri_extract_all_regex

Other rm_.functions: as_numeric, as_numeric2, ex_number, rm_number; as_time, as_time2, ex_time, ex_transcript_time, rm_time, rm_transcript_time; ex_abbreviation, rm_abbreviation; ex_angle, ex_bracket, ex_bracket_multiple, ex_curly, ex_round, ex_square, rm_angle, rm_bracket, rm_bracket_multiple, rm_curly, rm_round, rm_square; ex_between, ex_between_multiple, rm_between, rm_between_multiple; ex_caps_phrase, rm_caps_phrase; ex_caps, rm_caps; ex_citation_tex, rm_citation_tex; ex_citation, rm_citation; ex_city_state_zip, rm_city_state_zip; ex_city_state, rm_city_state; ex_default, rm_default; ex_dollar, rm_dollar; ex_email, rm_email; ex_emoticon, rm_emoticon; ex_endmark, rm_endmark; ex_hash, rm_hash; ex_nchar_words, rm_nchar_words; ex_non_ascii, rm_non_ascii; ex_non_words, rm_non_words; ex_percent, rm_percent; ex_phone, rm_phone; ex_postal_code, rm_postal_code; ex_repeated_characters, rm_repeated_characters; ex_repeated_phrases, rm_repeated_phrases; ex_repeated_words, rm_repeated_words; ex_tag, rm_tag; ex_title_name, rm_title_name; ex_twitter_url, ex_url, rm_twitter_url, rm_url; ex_white, ex_white_bracket, ex_white_colon, ex_white_comma, ex_white_endmark, ex_white_lead, ex_white_lead_trail, ex_white_multiple, ex_white_punctuation, ex_white_trail, rm_white, rm_white_bracket, rm_white_colon, rm_white_comma, rm_white_endmark, rm_white_lead, rm_white_lead_trail, rm_white_multiple, rm_white_punctuation, rm_white_trail; ex_zip, rm_zip

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
## Numeric Date Representation
x <- paste0("Format dates as 04/12/2014, 04-12-2014, 04.12.2014. or",
    " 04/12/14 but leaves mismatched: 12.12/2014")
rm_date(x)
ex_date(x)

## Word/Abbreviation Date Representation
x2 <- paste0("Format dates as Sept 09, 2002 or October 22, 1887",
  "but not 04-12-2014 and may match good 00, 9999")
rm_date(x2, pattern="@rm_date2")
ex_date(x2, pattern="@rm_date2")


## Year-Month-Day Representation
x3 <- sprintf("R uses time in this format %s.", Sys.time())
rm_date(x3, pattern="@rm_date3")

## Grab all types
ex_date(c(x, x2, x3), pattern="@rm_date4")

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.