cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NickFel Frequent Visitor
Frequent Visitor

Extract text based on string

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 ColumnDesired Column
Value-setA;set-Value;set-Value;RandoM;CustomerNValue-setA
set-Values;set-Value;Value-setB;RandomzValue-setB
set-Values;set-Value;Value-setB-var2;RandomzValue-setB-var2
set-Values;set-Value;Randomz;Value-setB

Value-setB

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Extract text based on string

check pbix at this link

 

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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
Super User
Super User

Re: Extract text based on string

check pbix at this link

 

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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

NickFel Frequent Visitor
Frequent Visitor

Re: Extract text based on string

Thanks! That was quick

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 396 members 3,173 guests
Please welcome our newest community members: