Filter by Expression Tools
When a simple condition isn't enough, write an expression that is true for the rows of your file you want to keep. Combine conditions with and/or, compare two columns, calculate values, or check parts of a date such as the month or weekday. Click a column name or an example to insert it, and see how many rows were kept and removed.
Filter by Expression
- Filter rows by expression in ACES
- Filter rows by expression in Avro
- Filter rows by expression in BMEcat
- Filter rows by expression in CSV
- Filter rows by expression in ETIM xChange
- Filter rows by expression in Excel
- Filter rows by expression in Excel Binary
- Filter rows by expression in Excel97
- Filter rows by expression in JPEG
- Filter rows by expression in JSON
- Filter rows by expression in JSON Lines
- Filter rows by expression in OFX
- Filter rows by expression in ORC
- Filter rows by expression in PDF
- Filter rows by expression in PIES
- Filter rows by expression in PNG
- Filter rows by expression in Parquet
- Filter rows by expression in Peppol UBL
- Filter rows by expression in QuickBooks
- Filter rows by expression in Quicken
- Filter rows by expression in TSV
- Filter rows by expression in WebP
- Filter rows by expression in XML
- Filter rows by expression in cXML