Solved: Order Of Execution

RAHULBANDI · ‎08-25-2022

Hi

I have used following formula to eliminate

Bonus 1:1 to Bonus

Table.SplitColumn(#"RenamedColumnType", "Action Type", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9",":"}, c), {"0".."9"}), {"Action Type", "Action Type.2"})

can someone explain me the order of excution of this formula step by step

Ehren · ‎08-26-2022

This is saying: split the "Action Type" column into two columns ("Action Type" and "Action Type.2") at the first point where a character that isn't a digit or a colon is followed by a digit.

View solution in original post

Ehren · ‎08-26-2022

This is saying: split the "Action Type" column into two columns ("Action Type" and "Action Type.2") at the first point where a character that isn't a digit or a colon is followed by a digit.