Regex Command in Magic ETL for cutting the end of a group of URL strings

Reply
Highlighted
Visitor

Regex Command in Magic ETL for cutting the end of a group of URL strings

I've seen a few similar topics but I was unable to know for sure...

 

I am new to Domo and was attempting to cut the latter part of several URL's.

 

For example...

 

.../safety-organization

.../safety-organization?cid=adv...

.../safety-organization?utm_=...

 

So in this case the latter parts of the URL's are email marketing tracking and I want the data to combine them all to look like the non-tracked version (the first URL). My thought was to make a Regex command saying to find the "?" and remove that and everything following it.

 

In Magic ETL I did a Replace Columns and the Regex command I used was \?(.*) after looking online at Regex documentation and then left the 3rd box blank because I didn't want it replaced with anything. Am I on the right track? As far as looking at the data there were many more instances of that URL so obviously it did something. I have noticed there are several versions of Regex depending on the language of the system so I would appreciate any feedback on my specific question as well as advice going forward on the type of syntax needed in Domo (similar to javascript, php, etc.)

 

Thanks!

Announcements
September release notes Check out the details of our latest product release. Click here!