How to use str_detect with multiple words

[ksingh19]

Hi,

I want to remove few rows that contain different words. For example, variable Country has several countries in it and I want to exclude the rows with Mexico and Cambodia. I was trying to do something like this:
df <- df %>%
filter(str_detect(Country, "Mexico", "Cambodia", negate = TRUE))

How can I remove rows with specific words in it?

Thanks!

[FJCC]

In a regular expression, | means OR.

library(stringr)
library(dplyr)

DF <- data.frame(Country = c("Austria", "Cambodia", "Congo", "Mexico", "Nepal"))
DF
#>    Country
#> 1  Austria
#> 2 Cambodia
#> 3    Congo
#> 4   Mexico
#> 5    Nepal
DF <- DF %>%
  filter(str_detect(Country, "Mexico|Cambodia", negate = TRUE))
DF
#>   Country
#> 1 Austria
#> 2   Congo
#> 3   Nepal

^{Created on 2020-06-15 by the reprex package (v0.3.0)}

[ksingh19]

Thanks @FJCC! Why didn't I think about including OR? Anyhow, it seems like str_detect doesn't work right for me for some reason. Here is my code and Error:

Thanks for your help!

[FJCC]

Do not put quotes around each country name. Put quotes around the entire regular expression.
Not this

"MEX"|"ExportCamexca"

Use this

"MEX|ExportCamexca"

[ksingh19]

Perfect! It works...Thank you!