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 extarct the value for templateid'f from above url ie.     TitleMetricsV2  in new column.

Please help?