Forum Discussion

agd50's avatar
agd50
Helper V
10 months ago
Solved

Conditional M Code - Removing a whole value from column IF a character is there

I want to remove an entire value if there is a "+" symbol, so it will be blank.

Example: "123+456" - I want this whole value removed (change to null)
How to achieve this in power query?

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    10 months ago

    Hi,

    This M code works

    let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Uppercased Text" = Table.TransformColumns(Source,{{"Data", each if Text.Contains(_,"+") then null else _}})
in
    #"Uppercased Text"

    Hope this helps.

     

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    10 months ago

    Hi,

    This M code works

    let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Uppercased Text" = Table.TransformColumns(Source,{{"Data", each if Text.Contains(_,"+") then null else _}})
in
    #"Uppercased Text"

    Hope this helps.