This action allows you to filter CSV data records based on specified conditions. All records that do not meet your criteria will be deleted. This can be useful to reduce data for further processing if needed.
Delete rows that...
Record deletion mode:
• ...don't match filters - keep only the records that meet your conditions. The remaining records will be deleted.
• ...match filters - delete all records that meet your conditions.
Choose the condition combination mode: AND (all listed conditions must be met) or OR (at least one condition must be met).
•Each condition corresponds to a specific column.
•Substring or regular expression - The condition string. By default, the action checks for the presence of the specified substring in the field value. You can indicate that the action should use this expression as a regular expression. Regular expressions are more flexible for defining conditions but require some skills.
•Case sensitive - yes or no
•Regular expression - yes or no. How to use condition string: as regular expression (yes) or as substring (no)
Source and Source format
Note: This feature is available for Business license only