My original line in the query editor is
Table.Replace(#“PreviousStep”,null,"…",Replacer.ReplaceValue,{“ColumnName”})
I am hopin this replaces a null in a text column with …
Can I extend this to replace empty strings as well as null as I am anticipating bad data from the source system?
Thanks
E