Data Workbench remove parameter from URL string

Hi all,

I have a pagename which in some cases includes a url pass through parameter that I want to remove, while maintaining others. I can't figure out whether/which transformation could be applied to help me do this, currently the reports are coming out like this:

Page Name,                                                                                                                                     Visitors
https://www.examplesite.com/customerpage?unwanted_parameter=123&wanted_parameter=1,   1
https://www.examplesite.com/customerpage?unwanted_parameter=456&wanted_parameter=1,   1
https://www.examplesite.com/customerpage?unwanted_parameter=789,                                        1
https://www.examplesite.com/customerpage?unwanted_parameter=101&wanted_parameter=2 ,   1
 

But I'd like to transform out the unwanted_parameter to return

Page Name,                                                                                           Visitors
https://www.examplesite.com/customerpage?wanted_parameter=1,     2
https://www.examplesite.com/customerpage?,                                       1
https://www.examplesite.com/customerpage?wanted_parameter=2,     1
 

Any help would be much appreciated.

Cheers, J.