Re: Code Misses a Replacement

[Xaositect]

in reply to Code Misses a Replacement

This may makes things more complicated than you need, but I should point out that most CSV dumps use quotation marks to escape strings that have commas in them. This is something to watch for: some,comma-delniated,"file with a, comma",in the data

You might take a look at Text::CSV, you could do something like: (untested)

use Text::CSV;
my $csv = Text::CSV->new();
while (<>) {
  $csv->parse($_);
  print join("\t", $csv->fields()); 
}

That's pretty simplistic, and won't handle tabs in the data, but you get the idea.

[radiantmatrix]

I would agree that the dump may do many interesting things when it goes to CSV, including escaping certain chars. I suggest the following code (which I use a variation of to convert Semi-Colon SV files to CSV files):

use IO::File;
use Text::CSV_XS;

for (@ARGV) {
   my $out_fname = $_.'.dshield';

   my $inf  = new IO::File ( $_,'<' ) or die "Cannot read $_";
   my $outf = new IO::File ( $out_fname ,'>' ) or die "Cannot write $o
+ut_fname";

   my $csv_in  = new Text::CSV_XS;  # defaults work for most CSV's
   my $csv_out = new Text::CSV_XS({sep_char=>"\t"}); # use tabs

   until ($inf->eof) {
      my $line = $csv_in->getline($inf);
      $csv_out->print($outf, $line);
   }
} ## IO::File objects close automatically when they go out of scope

This gets used as:

c2t.pl file1.out {file2.out} {...}

, and writes the results to file1.out.dshield, etc. By using the Text::CSV_XS module, you will be certain of processing CSV and Tab-SV files correctly. Though it's more code, it performs quite well and it will likely save you grief in the future.