Forum Discussion
Splitting Columns without generating new column
Pretty old question, so I realize no one may ever see this, but...
Edit the code in the Formula Bar to remove the .1 from the first resulting column (so the result will be named the same as it is now), then delete any other columns after that from the formula.
So instead of this, the default behavior:
= Table.SplitColumn(#"Added Custom2", "Test", Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)), {"Test.1", "Test.2"})
Edit the end of the formula to this:
= Table.SplitColumn(#"Added Custom2", "Test", Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)), {"Test"})
It has the effect of just dropping everything after the 2 in the same column without creating any new ones