Extract string within a string then pivot on values

[Jbrown1]

I have a column called ‘TAGs’ with the below string for a row in question:

Looker_Channel:Search,Looker_LOB:Retail,Looker_Managedby:Agency,Looker_Region:AMER,Looker_AMRegion:AMER,Looker_Product:Store,Looker_Market:US,Looker_Owner:Direct,Looker_Type:Local,Region:AMER

However I am trying to create a custom dimension to pivot on the ‘Looker_Type’ value (after the colon).

In the above string the Looker_Type (shown in Red) shows ‘Local’, but there can be up to 6 different words instead of ‘Local’, all with different character length

I'm really struggling to extract the string then pivot on it. I tried following similar steps on the below article, but I just can’t seem to get it to work: 

https://community.looker.com/technical-tips-tricks-1021/how-can-i-split-a-string-at-a-certain-charac...

Id really appreciate someone’s help here.

Many thanks