I received a .txt file with tab-delimited fields. The file contains 65K-plus records.
I want to edit the file, removing some records. Specifically, I want to find all records that contain a particular word--let's say "taffy"--in any of its fields. The field may--or may not--begin with "taffy", it may be the 2nd or 3rd word in a field.
I have imported this .txt file in Apple Numbers as a spreadsheet, but am happy to use a database app (that's free or cheap) to do this.
The end result will be used as a simple look-up table and can be either a spreadsheet or database file.
What app will allow me to search this file and group records according to the results (containing "taffy" in one of the fields) so that they can be multiple-selected and deleted?
Maybe I'm looking for an app that allows use of Boolean or Regular Expressions in its search function? And can group records according to the search results.