Home › Topic › Exclude Tweets with "@"

Exclude Tweets with "@"

Posted on by JaimeJCandau Posted in

Home › Forums › Advanced usage › Exclude Tweets with "@"

Tagged: , ,

This topic contains 4 replies, has 2 voices, and was last updated by  JaimeJCandau 5 years, 8 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • June 26, 2015 at 6:33 pm #499

    JaimeJCandau
    Participant

    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

    mhawksey
    Keymaster

    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

    JaimeJCandau
    Participant

    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

    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/

    June 29, 2015 at 7:44 pm #503

    JaimeJCandau
    Participant

    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.