I have a CSV that's separated like so with no header:
epochtime,#value,#value,property=1.property=2.property=3
The individual properties are separated by periods but are contained within a single column in the csv.
I am trying to run a blacklist with a list of properties to filter through the specific properties. I am using this grep function below:
grep -vFf blacklist.txt file.csv > newfile.csv
However it returns with no results. When I remove the other values and epoch time, it works perfectly leading me to suspect the periods might not be an issue.
Is there a way I can ignore the other two columns and still have it return the proper results?
Thanks in advance. I am quite new to unix. Would an awk command be better suited?
-F
(fixed strings) flag. Can you post a specific minimal example of afile.csv
and ablackist.txt
that demonstrate the issue?