Remove values after "?"

[ulysses_no]

Hi,

I have a report from Google Analytics that I want to wash.  Basically it's the same page, but with different tracking or filter values that gets recorded. 

Example:

Page URL	Views
/test/test1/test2/ID/Catalog.html?Event=promotemenu	471
/test/test1/test2/ID/Catalog.html?Event=filter=1	300
/test/test1/test2/ID/Catalog.html?Value=2	10
/test/test1/test2/ID/Catalog.html?MaxValue=2	251

I would like to remove everything after "?" AND the views to be summarised like this:

Page URL	Views
/test/test1/test2/ID/Catalog.html	1032

How do I do this?

Thanks in advance for your help!

[apathetichell · Accepted solution]

This should do the trick...

[Luke_C · Accepted solution]

Hi @ulysses_no 

Here's two options, one regex one with a formula. This assumes only one ? in the URL data.

Formula: Uses a Left function with a nested FindString function to take everything left of the ?

Regex: looks for the ? and everything after and removes it (replaces with nothing)