awk -F '","' 'BEGIN {OFS=","} { if (toupper($5) == "STRING 1") print }' file1.csv > file2.csv
Ausgabe
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""
"23525","74535243123","string , with commas, and - hypens and: semicolans","string with or, without commas","string 1","CAND","744","70%","05/06/2013",""
Ich denke, das ist, was Sie wollen.
Das Problem bei CSV ist, dass es keinen Standard gibt. Wenn Sie häufig mit CSV-formatierten Daten arbeiten müssen, sollten Sie nach einer robusteren Methode suchen, anstatt nur "," zu verwenden als Feldtrenner. In diesem Fall Perls Text::CSV CPAN-Module eignen sich hervorragend für diesen Job:
$ perl -mText::CSV_XS -WlanE '
BEGIN {our $csv = Text::CSV_XS->new;}
$csv->parse($_);
my @fields = $csv->fields();
print if $fields[4] =~ /string 1/i;
' file1.csv
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""
"23525","74535243123","string , with commas, and - hypens and: semicolans","string with or, without commas","string 1","CAND","744","70%","05/06/2013",""