Home › Reply › Reply To: Exclude Tweets with "@"

Reply To: Exclude Tweets with "@"

Home › Forums › Advanced usage › Exclude Tweets with "@" › Reply To: Exclude Tweets with "@"

June 29, 2015 at 6:49 pm #502
mhawksey
Keymaster

It’s actually relatively easy to filter out those tweets using the built in Google Sheet QUERY formula. In a new sheet something like

=QUERY(Archive!A:Q,”SELECT * WHERE NOT C CONTAINS(‘@’)”,TRUE)

More recipes mentioned in https://mashe.hawksey.info/2013/02/lak13-recipes-in-capturing-and-analyzing-data-twitter/