Forum Discussion

Jpahl2033's avatar
Jpahl2033
Helper I
4 years ago
Solved

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...
Need Help
Tips and Tricks
  • Syk's avatar
    Syk
    4 years ago

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

     

mh2587's avatar
mh2587
Super User
4 years ago
Found_Text = iferror(MID('table'[column], find("FPTS", '8HP_Tatoo_Today_Link'[TEXT_1]), 9), "")