Forum Discussion
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...
Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!
Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!