fork download
  1. data <- c("DETROIT","DETROIT USA","DETROIT UNITED STATES")
  2. keep <- c("USA","UNITED STATES")
  3.  
  4. regex <- paste0(".*\\s*\\b(",paste0(keep,collapse="|"), ")\\b")
  5. sub(regex, "\\1", data)
  6.  
Success #stdin #stdout 0.25s 39420KB
stdin
Standard input is empty
stdout
[1] "DETROIT"       "USA"           "UNITED STATES"