Extracting Regex in R

Asked May 26 '20 at 20:13

Active May 26 '20 at 20:17

Viewed 24 times

I'm new to R, but used to regex in Perl and I'm trying to pull information using regular expressions from a file that I've downloaded. Here's what isn't working:

regex <- "([\\w\\.\\,]{1,10})[ ]*?([\\w\\d-]*).*?(\\d{6}).*?(\\d\\d\\d\\d\\-\\d\\d\\-\\d\\d)(.*)"
line <- "allied          8-K         927454      2020-01-21  edgar/data/0001683168-20-000194.txt"
grep(regex, line, value = TRUE, perl = TRUE)

When I run the code, it returns the entire line.

I want a list (or something like a list) that returns "allied", "8-K", "927454", "2020-01-21", and "edgar/data/0001683168-20-000194.txt"

I also tried

str_extract_all(line, regex)

with the same results. I've tested my pattern at regex101.com and it works fine there.

edited May 26 '20 at 20:17

Cyrus

84,225
14
89
153

asked May 26 '20 at 20:13

Eric

1

`grep` does exactly that, it returns whole records matching a regex. You need `regmatches` with `regexpr` / `regexec`, or `stringr::str_match` – Wiktor Stribiżew May 26 '20 at 20:14
2

in R, do `strsplit(line," +")` – Onyambu May 26 '20 at 20:19

Extracting Regex in R

0 Answers0