split-datatable-rows

Finds rows in a datatable that match a pattern.

Splits datatable into two new datatables according to a specified pattern in the rows of a column. The pattern can be a text or a regular expression.

Arguments

Inputs:

data: The datatable to be searched and split into matching & non-matching rows.

column: The name of column in the datatable to be searched.

pattern: The text or regular expression to be searched for within the column.

regex: Treats pattern as a regular expression when set to True. If unspecified, defaults to False.

Output:

data: A datatable with the rows that match the pattern; otherwise, an empty datatable is returned.

complementary: A datatable with the rows that did not match the pattern.