How to split tag field string

[Anonymous]

Hi, 

I am a new user (very new).  

I am trying to split  the tag field string so that it returns me the actual tag(s), in seperate columns. 

example: {"i:OpCo":"Orange","i:fruit:"Greengrocer","i:Wholesale":"Mangobite"}

Ideally, I would want Orange, i:fruit &Greengrocer in seperate columns. 

Thanking in advance.

[Idrissshatila]

@Anonymous ,

check this if it works for you https://youtu.be/UC50_J8My9Q

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila]

Hello @Anonymous ,

The solution is ti split by delimiter in Power query.

refer to this documentation by microsoft for instructions https://learn.microsoft.com/en-us/power-query/split-columns-delimiter

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

Thank you for the swift response but delimiting isnt working for me. 

when I applu delimit to {"i:OpCo":"Orange","i:fruit:"Greengrocer","i:Wholesale":"Mangobite"} - delimiting with comma ... it does not delimit i:Wholesale":"Mangobite" because it contains a full stop. I tried splitting i:Wholesale":"Mangobite"again with delimiter but it wont let me. 

Is there a way to delimit this as well?

thanks