What is the best way to parse URLs?

sarahi6 · 2022-08-24T17:54:50+00:00

There was an error rendering this rich post.

I currently am bringing in data from google ads and one of the columns is `landing page url`.

I am trying to parse this row from:

https://m.ufhealth.org/uf-health-pregnancy-care?utm_source=google&utm_medium=tj%20ppc&utm_campaign=fy21%20ob%20services&gclid=EAIaIQobChMIo7Hl4pCq8gIV_21vBB1iYQ_JEAAYASAAEgJD3fD_BwE

to uf health pregnancy care only.

I am starting to learn expression but do not have all the knowledge yet to do this.

Find more posts tagged with

Magic ETL

Accepted answers

MarkSnodgrass

I would suggest using the split_part function to extract this.

split_part(
split_part(`Profile Picture URL`,'/',4)
 ,'?',1)

The innermost split_part will get the information after the slash that is after the base domain name. The outer split_part will then extract everything before the question mark.

Hope this helps.

All comments

MarkSnodgrass

I would suggest using the split_part function to extract this.

split_part(
split_part(`Profile Picture URL`,'/',4)
 ,'?',1)

The innermost split_part will get the information after the slash that is after the base domain name. The outer split_part will then extract everything before the question mark.

Hope this helps.

GrantSmith

Here's a REGEX version:

Something like this might work for you in a formula tile in Magic ETL 2.0:

REPLACE(REGEXP_REPLACE(`landing page url`, '^.*ufhealth\.org\/([^?]+).*$', '$1'), '-', ' ')

It's looking for your base URL and then pulling everything after it until it finds a ? character and ignoring everything before and after and then replacing it with just your page.

ST_Superman

@MarkSnodgrass - This is one of those times that I wish Domo's documentation kept up with Domo's updates. There is no SPLIT_PART() function listed in the beastmode function list, but it definitely works! I was just able to clean up some really nasty substring() beastmodes :)

MarkSnodgrass

@ST_-Superman-_ LOL! I'm glad it helped you do some cleanup. I agree with you on the documentation. This function and others show up in the formula tile in Magic ETL, but not when you scroll through the list when you are creating a beast mode in Analyzer. Scroll through the list when you are in Magic ETL and you will see quite a few more that you can use. I've only found a couple that didn't also work in Analyzer.

jaeW_at_Onyx

@zcameron "This is one of those times that I wish Domo's documentation kept up with Domo's updates. There is no SPLIT_PART() function listed in the beastmode function list"

@MarkSnodgrass and @ST_-Superman-_

while Domo does try to maintain parity between what we can do in formula tiles and what we can do in Beast Modes, it's important to keep in mind that Magic ETL is not executing in Adrenaline (whereas beast modes are).

All the formula tile formulas borrow from MySQL / Adrenaline formula syntax, but they are reduced/interpreted into Java (i believe).

Usually if there's a specific function missing it's an easy ask to toss it over to support / product feedback ... whether it'll actually get implemented might be a different question :P

jaeW_at_Onyx

blank post for the points :P sorry can't delete it.