Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add trim after Split

I am using this to Find/Replace a table   let Repl = Table.Buffer(ReplacementsTable), Text = Text, Result = Table.AddColumn(Text, "Changed Text Expected", each Text.Combine( List...
  • Vijay_A_Verma's avatar
    4 years ago

    Use below in place of Text.Split([Text], "|")

    Text.Split(Text.Replace(Text.Replace([Text]," |","|"),"| ","|") "|")