Replace Value with conditions in advanced editor

[Anonymous]

Hey All,

Got stuck with the syntax.

I want to replace values in a column.

Replace all values from a column where value not starting with specific text.

How can I do it?

 #"Replaced Value" = Table.ReplaceValue(#"Added Custom Column",each if [Custom] <> Text.StartsWith([Custom], "day=""") then "" else "bla",Replacer.ReplaceText,{"Custom"})

Cheers!
A

[jdbuchanan71]

Hello @Anonymous 

What about doing it in a new custom column?

= Table.AddColumn(#"Renamed Columns", "New column", each if Text.StartsWith([Custom], "day=""""") then "" else [Custom])

Then just delete the old column and rename the new one.

[Anonymous]

@jdbuchanan71 

Thats not a bad idea.

That is already a new custom column which I want to clean from leftovers.

But, I can do it. Create a new column and then maybe delete the original custom column.

Thnaks,

A