Extract text based on string

[NickFel]

Hello all I'm hoping that you can can help me out.

I have a table with quite a few columns. One of those columns has semicolon seperated values. These values can be in any order and number so I can't just pick x from a position.

What I am attemting to do is extract the values into a new column that have a unique starting string and always contain a -  (but can be varying lengths).

So something like this:

Existing Column	Desired Column
Value-setA;set-Value;set-Value;RandoM;CustomerN	Value-setA
set-Values;set-Value;Value-setB;Randomz	Value-setB
set-Values;set-Value;Value-setB-var2;Randomz	Value-setB-var2
set-Values;set-Value;Randomz;Value-setB	Value-setB

[parry2k · Accepted solution]

check pbix at this link

https://drive.google.com/open?id=0B4dPgH9_BPBrUk81a2hHV200cFE

[NickFel]

Thanks! That was quick