How do I clean this up?

[jlowelowe]

(Apologies if I'm posting this in the wrong place. If so, I'm happy to be sent off in the right direction.)

I'm trying just to create a table, for now. I imported a .CSV into Power BI and one my columns is filled with values that looks like this:

{"or":[{"tag":"northbay","group":"otvTagGroup"},{"tag":"napa","group":"otvTagGroup"},{"tag":"petaluma","group":"otvTagGroup"},{"tag":"sanrafael","group":"otvTagGroup"},{"tag":"santarosa","group":"otvTagGroup"},{"tag":"sonoma","group":"otvTagGroup"}]}

What's the best way to go about cleaning this up? All I need are the terms like: northbay, napa, petaluma, sanrafael, etc.

[jdbuchanan71 · Accepted solution]

Hello @jlowelowe 

In the query editor you can do some replace steps to clean it up.

Replace ","group":"otvTagGroup"} with nothing

Replace {"tag":" with nothing

Replace {"or":[ with nothing

Replace ]} with nothing

[jlowelowe]

Ok I see, I'll give this a shot. Thanks!