Finds the first full Windows or POSIX path ending in an `.xlsx` file name in each string, and splits it into folder and file name. Separators may repeat (`C:/data//out`, or `C:\\data` as written in R code). Relative paths such as `output/t1.xlsx` are not full paths and give `NA`.
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 tibble with one row per element of `x`: `dir`, `file`, and `full_path` (`NA` where no path was found).
Examples
extract_xlsx_paths(c("C:\\data\\table_1.xlsx", "/home/me/out/table-2.xlsx", "none"))
#> # A tibble: 3 × 3
#> dir file full_path
#> <chr> <chr> <chr>
#> 1 "C:\\data" table_1.xlsx C:/data/table_1.xlsx
#> 2 "/home/me/out" table-2.xlsx /home/me/out/table-2.xlsx
#> 3 NA NA NA