How to extract a substring from an URL

Options
qzqzqzqzqz
qzqzqzqzqz Member
in Dashboards

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

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓ 
    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!**
  • david_cunningham
    david_cunningham Coach
    Answer ✓ 
    SUBSTRING_INDEX(url,'/',2)
    image.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓ 
    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!**
  • david_cunningham
    david_cunningham Coach
    Answer ✓ 
    SUBSTRING_INDEX(url,'/',2)
    image.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • qzqzqzqzqz
    qzqzqzqzqz Member

    thank you both! unfortunately my beastmode has neither substring_index or split_part. is there a reason I don't see the functions

  • qzqzqzqzqz
    qzqzqzqzqz Member

    Actual both worked although the functions do not show up in Beast Mode. thank you both!!!

  • GrantSmith
    GrantSmith Coach

    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!**

Categories