Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there!
I have a messy column that I need to split off the first instance of digit (the number of digits differs by each row) and leave the rest of the cell contents as is.
I tried to Split Column Digit to Non Digit which is almost there, but it splits off at every instance of digit (ie. will extend to 4 or more custom columns).
Example:
Any ideas?
Thanks 🙂
Solved! Go to Solution.
hi, @JNelson
let
Source = table_with_messy_column,
chars = List.Buffer({"a".."z", "A".."Z", " "}),
split = Table.SplitColumn(
Source, "Logistics",
(x) => Splitter.SplitTextByPositions(
{0, List.PositionOfAny(Text.ToList(x), chars, Occurrence.First)}
)(x),
{"Custom", "Custom.1"}
)
in
split
hi, @JNelson
let
Source = table_with_messy_column,
chars = List.Buffer({"a".."z", "A".."Z", " "}),
split = Table.SplitColumn(
Source, "Logistics",
(x) => Splitter.SplitTextByPositions(
{0, List.PositionOfAny(Text.ToList(x), chars, Occurrence.First)}
)(x),
{"Custom", "Custom.1"}
)
in
split
Hi @AlienSx ,
May be a silly question, but how do I insert that into my existing Advanced Editor?
My last step is currently #"Removed Other Columns". I think I'm getting confused because this looks like an entire editor (with the let and in parts).
Thanks!
Thank you! Got it.