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!
Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!
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!
Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
