How to extract a substring from an URL
I'm trying to extract the substring from an URL.
Input: www.abcd.com/level1/level2
The output I'm looking for is essentially taking from the first character to the position of the second '/' minus 1. I wonder how to write the formula in beast mode.
Desired output: www.abcd.com/level
Best Answers
-
CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2))
SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible.
Concat then takes those two values and combines them together with the / inbetween
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
SUBSTRING_INDEX(
url
,'/',2)David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**3
Answers
-
CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2))
SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible.
Concat then takes those two values and combines them together with the / inbetween
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
SUBSTRING_INDEX(
url
,'/',2)David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**3 -
thank you both! unfortunately my beastmode has neither substring_index or split_part. is there a reason I don't see the functions
0 -
Actual both worked although the functions do not show up in Beast Mode. thank you both!!!
0 -
There's several functions which aren't listed in the function list but do still exist. Hopefully Domo gets it updated.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 593 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 96 Manage
- 93 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive