I have a CSV file with 4 columns: Date
, User
, Email
and Comment
How would I filter the rows that have too much, later
in the Comment
column and then read it into a new file called input1.csv
?
Below is what I tried, but input1.csv
came out blank:
awk -F , '$4 == "too much, later" { print }' input.csv > input1.csv
Here is the sample input:
Date,User,Email,Comment
11/22/16,aaaa,[email protected],too much,later