How to remove a query string from a URL

Task

URLs arrive with ?utm_source=... and sometimes with #fragment. The result needs a clean URL without parameters.

Short answer

In clean_url, remove everything after ?, then remove ?; use the same pair of rules for #.

How to do it in Eofferix

Upload the table with URLs and open the table editor.
The clean_url column shows URLs without parameters and fragments.
Create clean_url from url and add rule pairs for ? and #: Remove after, then Remove substring.
Each pair cuts the string by a separator and then removes the separator itself.
Check rows with only a query string, only a fragment, and no parameters.
Save the template and use clean_url in the export.

The data below is a training example and does not belong to real user files.

source data

id	url
1001	https://site.example/catalog/item.html?utm_source=ad&utm_campaign=spring
1002	https://site.example/files/manual.pdf#page=2

result

id	clean_url
1001	https://site.example/catalog/item.html
1002	https://site.example/files/manual.pdf