Forum Discussion
How to split tag field string
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...
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 👍
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