Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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","i:Wholesale":"Mangobite"}

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

 

Thanking in advance.

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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