Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.