Pulling Data from Tags Field Azure Dev Ops

[Sopanda]

We are using Azure Dev Ops as our source and pulling it into Power BI.

Our work items contains a bunch of tags in a specific schema.

I want to be able to search if a work item contains a specific word in the tags field (i.e. Animal:XXX; House:XXXXX; )

So i want it to look for House: and than pull the House data into a new column. Is this possible?

[Anonymous]

@Sopanda  I am not following you. Do you like to match and catch a row from 2 different tables or all in the same table? Please share your sample data replicate to be able to help you better

Sepehr07

[Sopanda]

Thanks for replying so quick. 

Here's a table and the outcome of what I want to achieve. 

[Anonymous]

If I got you right, it it a really simple problem:

in Power Query you can easily use split by delimeter, then choose by ; on the delimeter type and finally you will have 3 different columns as you wish. You can change the column headers as your wish.

hope it helpI hope this helps.

If it does, please Mark as a solution.
I also appreciate Kudos.

[Sopanda]

What if it's something like this?

I want to be able to search if the Tags field contains Animal: or House: and have it pull whatever information is between that and the next semicolon (;). Is there a good if statement that can fulfil this?