I'm looking to write a Beast Mode to extract hashtag strings from social media posts
Hello, I want to write a beast mode to use as a card filter to filter by hashtag strings in posts. Can you write a beast mode to extract all the strings following the # symbol? "Mmmm #yummy #donut at #CZ"
I want to filter the card by every post that contains either yummy, donut, or cz.
@Shwane You can use CASE WHEN and LIKE to accomplish this (assuming it's just the three things you're looking for:
case when 'post' like '%#yummy%' or 'post' like '%#donut%' or 'post' like '%#CZ%' then 'Yummy/Donut/CZ'
else 'Other' end
If you have a bunch more tags that you would need to extract, then it gets a bit more complex.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Thanks, Rob, but I do have many more Posts to extract unfortunately. I've been trying to use substrings with no luck. So far, my best bet seemed to be using regex in Magic ETL.0
@Shwane when your string has an unknown amount of phrases you are looking for, you are going to need to use Magic ETL to break it up. I created a video on how to do this. In my case, I am looking for spaces, so you will need to change that and look for the hashtag, potentially.
Here is a link to the video:**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Thanks, Mark! I'll check out the video today and apply it to my case. I've been trying to use RegEx within Magic ETL and was able to obtain the first hashtag from a post but not the ones after the first.0
- 7.7K All Categories
- 3 Connect
- 919 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 37 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 18 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 27 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部