Exclude Tweets with "@" Home › Forums › Advanced usage › Exclude Tweets with "@" Tagged: exclude, mentions, replies This topic has 4 replies, 2 voices, and was last updated 7 years, 7 months ago by JaimeJCandau. Viewing 5 posts - 1 through 5 (of 5 total) Author Posts June 26, 2015 at 6:33 pm #499 JaimeJCandauParticipant 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 June 27, 2015 at 9:20 am #500 mhawkseyKeymaster I think the best you can do is exclude replies to specific accounts using something like #yourtag AND -to:mhawksey Would this be enough? June 29, 2015 at 3:50 pm #501 JaimeJCandauParticipant 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 June 29, 2015 at 6:49 pm #502 mhawkseyKeymaster 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/ June 29, 2015 at 7:44 pm #503 JaimeJCandauParticipant Ohhh…. that’s a whole new world to explore ;p Thanks! Jaime Author Posts Viewing 5 posts - 1 through 5 (of 5 total) You must be logged in to reply to this topic. Log In Username: Password: Keep me signed in Log In