String splitting & Conditional Column help

[Anonymous]

hi, 

I am really struggling here as I am a new user and help would be much appriciated. 

I have an extract in Excel which has long tagsas shown below: 

 {"i:OS":"Popil","i:City":"Ghana_","i:OpCo":"Fruitella","i:Region":"NA","i:Green:"Banana","i:Greengrocer":"Fruit"}

I really want a solution to :

1.  Put "Banana" in a seperate column & "Not Fruit" for the rest

2. Fruit in another seperate column and 'Non Fruit" for the rest

I have used the delimiter but it only seperated by comma or colon, some how does not seperate each word.  Can anyone provide me with a complete solution?

Thanks in advance

[Ahmedx]

Can you please share your demo input and expected output!

It is not clear what result you expect