extract string from url value..help

hi, i have a column with values like this  'https://xlens-odata.xboxlive.com/odata/clusters/QueryTemplate(id='xlensxdm',templateid='TitleMetricsV2', indices=@i, parameters=@p)'   i need to extarc...