ファイルの 5 番目の列の値に基づいて .CSV ファイルをフィルター処理し、それらのレコードを新しいファイルに出力します。

awk -F '","'  'BEGIN {OFS=","} { if (toupper($5) == "STRING 1")  print }' file1.csv > file2.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",""

これがあなたの望むものだと思います。

CSV の問題点は、標準がないことです。 CSV 形式のデータを頻繁に処理する必要がある場合は、単に "," を使用するのではなく、より堅牢な方法を検討することをお勧めします。 フィールド区切りとして。この場合、Perl の Text::CSV CPAN モジュールは、この仕事に非常に適しています:

$ 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",""