I am not able to attach the CSV file, so I have attached the images so that the content is clear. I used awk
and perl
one liners but that is not giving any output. Please help me know, how can I get the rows with matching column number and column text/value.
can this be written in form of a script than command.
$ perl -F, -lane 'print if $F[8]==WINDOWS2000-2' Compare_20180715191103.csv
and
$ awk -F, -v OFS=, '$8 == "WINDOWS2000-2 "{ print }' Compare_20180715191103.csv
H
) does not seem to contain the stingNAB-ITSA-SOLARIS
norNAB-ITSA-LINUX-7
(which should have been double quoted in the Perl code btw). – Kusalananda♦ Jul 24 '18 at 14:23Text::CSV_XS
which is probably the best module for any language to process CSVs. And likely the fastest without doing the very same thing in C yourself. It's a shame that the module isn't a library that other languages can mooch off of. – Evan Carroll Jul 24 '18 at 19:33cat -vet Compare_20180715191103.csv
from the command line ? – Rakesh Sharma Jul 25 '18 at 5:06