Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cottrera
Post Prodigy
Post Prodigy

Extract Text String from column to a new column

Hi 

 

I have a table called REPAIRS with a column called JOB_DETAILS.  I need to extract certain text from this column to a new column. The list of text words that I need to extract are as follows ,

(Contractor)
(Parts)
(Scope)
(Book)

 If the words above do not appear in the Job_Details column I need the new column to be blank

The comas need to be included.

 

thankyou

 

RIchard

1 ACCEPTED SOLUTION

Hi @cottrera ,

 

Would you please try to use condition column in query editor:

 

Untitled picture2.png

 

Best Regards,

Dedmon Dai

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

So, will only one of those words appear in a row at a time?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi thanks for the quick response. Yes that right only one of these words will ever appear per row at any time.

 

Richard

Hi @cottrera ,

 

Would you please try to use condition column in query editor:

 

Untitled picture2.png

 

Best Regards,

Dedmon Dai

Awesome thank you very much this works fine

 

RIchard

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.