Splitting text from a tag and marking in separate column

[Mee2105]

Hello, 

new user here, just started yesterday and trying to figure out my way here & I need your help. 

I am have my list here in excel where there are a number of servers and workstations but these are hidden in tags. 3 examples:

1.  {"i:OS":"vintage","i:City":"Paris","i:OpCo":"WT","istreet":"OnPremise","i:France":"EMEA","i:SubOpCo":"Alphonso","i:banana":"Server","i:fruittype":"Creative","i:Seller":"Mango"}

2. {"i:OpCo":"Hawaii","i:Archetype":"Kesar","i:Seller":"Mango"}

3. {"i:OS":"Window","i:City":"Singapore","i:OpCo":"Kannu,"i:Cloud":"OnPremise","i:Region":"APAC","i:SubOpCo":"Totapuri","i:Platform":"Workstation","i:Archetype":"Creative","i:Sellert":"Mango"}

What I really need to do is : 

1. Find the word 'server' in the tag and mark as 'server' in a seperate column (say column x) &

2. default everything else as 'workstation'.

I have managed to do this in excel but cant figure it out in excel.

Thanks in Advance 

[mlsx4 · Accepted solution]

Hi @Mee2105 

In Power Query Editor, create a conditional column in this way:

Please, be aware that if the word Server appears as "server" or "SERVER" you should include all these words in the condition. Power BI is case-sensitive