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

[agd50]

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?

[Ashish_Mathur · Accepted solution]

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.