1 Reply Latest reply on Jan 17, 2019 6:09 AM by Seth Nelson

    Extracting all hashtags from Tweets

    Marjolein Krijgsman
    Marjolein Krijgsman Jan 17, 2019 5:50 AM

      Hi all,

       

      I want to extract all hashtags in tweets. I tried out this calculated field on the Message dimension (which the content of the tweet, a string):

       

      REGEXP_EXTRACT([Message],'#([a-zA-Z0-9_]+)')

       

      I'm pretty sure I only get back the first hashtag in the message, however I actually want to extract all of them. Some tweets include only one hashtag, but most include multiple.

      What calculation can I use to do so?

       

      Thanks in advance,

       

      Marjolein