Datatune

Filter rows in a CSV or Excel file by a condition

Sometimes the fix is not changing the data but removing the part of it you never wanted. Upload the file, set a condition on a column, and download only the rows that survive it.

Filter a file

Conditions you can set

A filter compares one column against a value. Seven comparisons are available, covering both numbers and text.

Keeping and deleting are the same step

Keep what matches

The matching rows stay and everything else is discarded. This is the direction to use when you know what you are looking for, such as one region, one status or one date range boundary.

Delete what matches

The matching rows are removed and the remainder is kept. This is the direction for cleaning, such as dropping test entries, cancelled orders or rows carrying a marker that a previous system wrote in.

Combining conditions

A single filter holds a single condition, but steps run in order and each one works on what the previous step left behind. Two filters in sequence therefore keep only the rows that satisfy both, which covers most of what a compound condition would be used for. A filter can also be combined with cleaning steps in the same pass, so the file is trimmed and reduced in one upload.

Questions

Can rows be deleted instead of kept?

Yes. The same condition works in both directions, so you either keep the matching rows and discard the rest, or delete the matching rows and keep everything else.

Can two conditions be combined?

Yes, by adding a second filter step. Steps run in order over what the previous step left behind, so two filters in sequence keep only the rows that satisfy both conditions.

How are partial text matches handled?

The contains operator matches a row when the column value holds the text anywhere inside it, which is the operator to use when the full value is not known in advance.

Related