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

Atieh

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

GrantSmith

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

REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?)?.*$', '$1')

GrantSmith

You can use REGEXP_REPLACE in a MagicETL formula tile:

REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?).*$', '$1')

Atieh

Thanks @GrantSmith

But it didn't work. Not sure why

Atieh

@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?

GrantSmith

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

REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?)?.*$', '$1')

Atieh

It worked Thanks! @GrantSmith

But still some of them has ? at he end

GrantSmith

You can use this updated regex:

REGEXP_REPLACE(`url`, '^.*\/([^\/]+\.pdf)(?:\?.*)?$', '$1')

Atieh

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