Description
Keep or remove a continuous section of rows.
Example
Keep only the rows between the 'YEAR' rows:
Inputs
One.
Options
•Set Mode depending on whether you want to keep or remove the slice.
•Set From according to how you want to choose the first row of the slice.
•Set Column, Matches and Value to match the first row. You can use a column variable for either Value.
•Uncheck Include 'From' row if you don't want to include the first row in the slice.
•Set To according to how you want to choose the last row of the slice.
•Set Column, Matches and Value to match the last row.
•Uncheck Include 'To' row if you don't want to include the last row in the slice.
•Check case sensitive to use case sensitive matching for text.
Notes
•If there is no match for the From or To row:
oMode=Keep will remove all rows
oMode=Remove will keep all rows
•Number, date and text values are treated differently for Equal to, Greater than, Less than, Greater than equal, Less than equal and Not equal to operations.
oIf both values are numeric, a numeric comparison will be carried out. This is accurate to approximately 16 digits of precision.
oIf both values match a supported date formats in Preferences, a date comparison will be carried out.
oOtherwise the values will be treated as text.
oFor example, an empty value is considered less than 0, because they will be compared as text. So you might want to replace empty values with 0 or remove those rows with Filter, before comparing them.
•All values are treated as text for Contains, Starts with, Ends with, Matches regex, Is not, Doesn't start with, Doesn't end with and Doesn't match regex operations.
•Comparisons of text are whitespace sensitive. Cells with whitespace will not match Is empty. You can use Whitespace to remove whitespace before filtering and Replace to get of other unwanted characters (e.g. whitespace inside the text).
•See here for more details on Regular expressions (regex).
•If you want to keep or remove a selection of rows by row number, use a Row Num transform followed by a Filter transform.