in reply to to csv file

Do you want trre,dsa to appear in one column or two ?. Your post shows two.

poj

Replies are listed 'Best First'.
Re^2: to csv file
by Anonymous Monk on Jun 29, 2013 at 07:41 UTC
    i am sorry it was a mistake , i want them as one
[reply]

      One way is to take advantage of excel's ability to open tab delimited text files with .xls extension

      #!perl
use strict;
open OUT,">test.xls" or die "$!";
while (<DATA>){
  s/;;/\t/g;
  print OUT;
}
close OUT;

__DATA__
abd;;sasa;;trre,dsa;;sdas;;dsss
abd;;sasa;;trre,dsa;;sdas;;dsss
abd;;sasa;;trre,dsa;;sdas;;dsss

      [download]
      poj
[reply]
[d/l]
        hey the thing is i need the output as csv , because it is an input to other sub routine
[reply]

In Section Seekers of Perl Wisdom