I have two files, a keepout.txt and a database.csv. They're unsorted, but could be sorted.
keepout:
user1
buser3
anuser19
notheruser27
database:
user1,2343,"information about",field,blah,34
user2,4231,"mo info",etc,stuff,43
notheruser27,4344,"hiya",thing,more thing,423
user5,6666,"test text",info,stuff,833
Output would be
user2,4231,"mo info",etc,stuff,43
user5,6666,"test text",info,stuff,833
Make sense? If a line in keepout matches a field (would be nice to just be first field) in database then I want to dump the line in the output.
I've tried awky ways and greppy ways but can't get it just right. It's not entire lines that are matching, just the lines. Kind of like a loopy grep -v.
Thanks for your help!