Exclude Tweets with "@"

[JaimeJCandau]

Hi,

Need to exclude anything with a “@” (to avoid registering Replies to a tweet and Mensajes to specific user)

Tried adding with a “-” and adding -%40 (which is the encoded for @), but no luck…

Hugely grateful for some thoughts
Jaime

[mhawksey]

I think the best you can do is exclude replies to specific accounts using something like #yourtag AND -to:mhawksey

Would this be enough?

[JaimeJCandau]

Hmmm…. That would remove some of it. I’ll give it a try!!!! Thanks!

Btw, the whole TAGS does the job anyways, this was just a little fine tuning, but definitely I’ll keep using it!!

Jaime

[mhawksey]

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/

[JaimeJCandau]

Ohhh…. that’s a whole new world to explore ;p

Thanks!
Jaime

[Author]

Posts