Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Removing unexpected text from a column

Hello, I have a column which contains a number of different word values that repeat numerous times down the column.  Sometimes there's instances where the these words have extra text at the end...
Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    Hi Anonymous 

     

    Why not try a custom column 

    if Text.Contains([Status], "Backlog") then "Backlog else
if Text.Contains([Status], "Archived") then "Archived" else [Status]

     

    Thanks

    Joe

    If this post helps, then please Accept it as the solution

     

JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

Hi Anonymous 

 

Why not try a custom column 

if Text.Contains([Status], "Backlog") then "Backlog else
if Text.Contains([Status], "Archived") then "Archived" else [Status]

 

Thanks

Joe

If this post helps, then please Accept it as the solution