I like to combine multiple replace with null/blank with Splitter.SplitByAnyDelimiter()![]()
#"Replace 0" = Text.Replace(GaugeInput,"0",""), #"Replace ." = Text.Replace(#"Replace 0",".",""), #"Replace MM" = Text.Replace(#"Replace ."," MM",""), #"Replace Second Choice" = Text.Replace(#"Replace MM","SECOND CHOICE","")
Ex:
Edit: Woops, forgot closing parenthesis.![]()
Text.Combine(Splitter.SplitTextByAnyDelimiter({"0","."," ","MM","SECOND CHOICE"})(GaugeInput))
Bookmarks