is there a workaround to use something like
filter(df, grepl("A|B|C",location))
for a dplyr SQL table? In SQL it is probalby a LIKE
. Of cource I could convert the SQL table to a R data table, but it is very large. (http://cran.r-project.org/web/packages/dplyr/vignettes/databases.html) At the moment I get
Error in sqliteSendQuery(conn, statement) :
error in statement: no such function: GREPL
thx Christof
Using sql
to translate the expression directly into sql is one option.
sql_table %>% filter( sql("location LIKE 'A%'
OR location LIKE 'B%'
OR location LIKE 'C%'")
Which will inject the following into the WHERE statement of your query:
<SQL> location LIKE 'A%' OR location LIKE 'B%' OR location LIKE 'C%'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With