Solved: Re: Extract text based on string

NickFel · ‎11-02-2017

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 · ‎11-02-2017

check pbix at this link

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.