Forum Discussion

jlowelowe's avatar
jlowelowe
New Member
6 years ago
Solved

How do I clean this up?

(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.

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    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