Using Substring Functions for URL Path Breakdown in Mixpanel

Hello , I have this simple question. Im analysing some web related events with the URL path. I want to get a web URL breakdown, but my data includes detailed paths that I don't need, as shown in the screenshot. How can I use a substring function to remove the unwanted part of the URL path? For example, something like IF SUBSTRING(URL_PATH, 1, 6) = '/jobs/' THEN 'Jobs'. When creating a customized bucket for breakdowns in Mixpanel, can I use a substring or similar function for this?