Extract Every `.xlsx` File Name From Text

Extract Every `.xlsx` File Name From Text

Usage

extract_all_xlsx_tokens(x, xlsx_token_re = xlsx_name_re)

Arguments

x

Character vector, e.g. code lines.

xlsx_token_re

Regular expression for the file-name part. The default matches a name ending in `.xlsx`: right after a quote or path separator it may contain spaces and punctuation other than quotes and separators; elsewhere only letters, digits, `_`, `.`, and `-`. Names followed by `(` (function calls such as `read.xlsx()`) are skipped.

Value

A list the length of `x`, each element a character vector of the `.xlsx` file names found in that string (empty when none).

See also

[extract_xlsx_paths()]

Examples

extract_all_xlsx_tokens(c("read_excel('out/a.xlsx'); write_xlsx(df, 'b c.xlsx')", "none"))
#> [[1]]
#> [1] "a.xlsx"   "b c.xlsx"
#> 
#> [[2]]
#> character(0)
#>