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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jpahl2033
Helper I
Helper I

Pulling out Text without delimiter

Hi,

 

I have a text column where i want to pull a word from the column. There are no delimitors to pull from. For the screenshot, i want to pull either PAT or Auto from column B. The words PAT/Auto are not always at the end of the text value so it is really just pulling the word from anywhere in the value. 

 

Thanks! 

 

Jpahl2033_0-1654702984151.png

 

1 ACCEPTED SOLUTION
Syk
Super User
Super User

Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!

Syk_0-1654703309809.png

 

View solution in original post

2 REPLIES 2
mh2587
Super User
Super User

Found_Text = iferror(MID('table'[column], find("FPTS", '8HP_Tatoo_Today_Link'[TEXT_1]), 9), "")

Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Syk
Super User
Super User

Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!

Syk_0-1654703309809.png

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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