Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replace string values with wildcard

I have the below list of points within a column and i am trying to have them all just say MaTmp and remove anything after that.  Is there a ways to do this like you do in excel with find *MaTmp*  an...
Need Help
  • Syk's avatar
    Syk
    4 years ago

    You can useExtract in power query editor.

    Example:

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Column 2 =
IF(
CONTAINSSTRING(
    'Table'[Column],"MaTmp") = TRUE() ,"MaTmp",BLANK())

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly