Skip to content

    • Beast Mode

    Beast Mode

    Extract the string values in between stroke and question mark in a URL

    Member
    in Beast Mode

    Hi Domo,

    I am looking for a way to extract the string values in between stroke and question mark in a URL

    Example URL:

    https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z

    I want to extract this part of URL: "67-making-AI-trustable.pdf"

    Ideally if I can do that with a beast mode formula would be great. But if there is any tile in the ETL that can help me would be helpful too

    Thanks

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      If you won't always have a ? in the URL and want to get the end of it you can make the ? optional by adding ? after the group

      1. REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?)?.*$', '$1')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      edited August 2024

      You can use REGEXP_REPLACE in a MagicETL formula tile:

      1. REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?).*$', '$1')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thanks @GrantSmith

      But it didn't work. Not sure why

    • Member

      @GrantSmith I looked at the URLs, some doesn't have ? that's why it didn't work for those

      Any idea how to make it work?

    • Coach
      Answer ✓

      If you won't always have a ? in the URL and want to get the end of it you can make the ? optional by adding ? after the group

      1. REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?)?.*$', '$1')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      It worked Thanks! @GrantSmith

      But still some of them has ? at he end

      image.png
    • Coach

      You can use this updated regex:

      1. REGEXP_REPLACE(`url`, '^.*\/([^\/]+\.pdf)(?:\?.*)?$', '$1')
      2.  
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      @GrantSmith This new one didn't work. Previous one was better

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories