Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
3 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"...
Need Help
  • Ehren's avatar
    Ehren
    3 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.

Ehren's avatar
Ehren
Microsoft Employee
3 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.