# separate_wider_regex works with tibbles# note also separate_wider_delimfilenames <-read_lines("data/filenames.txt")filenames <-tibble(names = filenames)filenames <- filenames |>separate_wider_regex(names, patterns =c(".*_",netid ="[a-z]{3}[0-9]{5}","_.*\\.",extension ="qmd|Rmd|pdf"), cols_remove =FALSE)# matches have to fill the line# use too_few = "debug" to get extra info if this fails (omit pdf from extension for example)filenames |>mutate(new_name =str_c(netid, ".", extension))
# A tibble: 40 × 4
netid extension names new_name
<chr> <chr> <chr> <chr>
1 aft85126 qmd HW2 - R - QMD_aft85126_attempt_2023-09-24-18-40-… aft8512…
2 pez35105 qmd HW2 - R - QMD_pez35105_attempt_2023-09-23-23-21-… pez3510…
3 qty84085 pdf HW2 - R - QMD_qty84085_attempt_2023-09-23-23-21-… qty8408…
4 min29847 qmd HW2 - R - QMD_min29847_attempt_2023-09-24-00-57-… min2984…
5 imk48906 qmd HW2 - R - QMD_imk48906_attempt_2023-09-24-13-30-… imk4890…
6 uwc08078 qmd HW2 - R - QMD_uwc08078_attempt_2023-09-24-00-03-… uwc0807…
7 kld62064 Rmd HW2 - R - QMD_kld62064_attempt_2023-09-24-18-53-… kld6206…
8 mnr42924 qmd HW2 - R - QMD_mnr42924_attempt_2023-09-24-22-44-… mnr4292…
9 kzs45796 qmd HW2 - R - QMD_kzs45796_attempt_2023-09-12-11-29-… kzs4579…
10 vhy10473 qmd HW2 - R - QMD_vhy10473_attempt_2023-09-24-22-34-… vhy1047…
# ℹ 30 more rows