d=data.frame(V1=c("xxx","yyy","zzz"), V2=c(NA,"ewruinwe",NA))
d
## V1 V2
## 1 xxx <NA>
## 2 yyy ewruinwe
## 3 zzz <NA>
apply(d, c(1,2), function(x) grepl("ruin", x))
## V1 V2
## [1,] FALSE FALSE
## [2,] FALSE TRUE
## [3,] FALSE FALSE
any(apply(d, 2, function(x) grepl("ruin", x)))
## [1] TRUE
#ref https://stackoverflow.com/questions/8999653/grep-on-any-cell-in-a-data-frame