Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
4 years ago
Solved

Order Of Execution

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

Need Help
  • Ehren's avatar
    Ehren
    4 years ago

    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.

1 Reply

  • Ehren's avatar
    Ehren
    Microsoft Employee
    4 years ago

    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.