Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^2: to csv file

by Anonymous Monk
on Jun 29, 2013 at 07:41 UTC ( #1041411=note: print w/ replies, xml ) Need Help??


in reply to Re: to csv file
in thread to csv file

i am sorry it was a mistake , i want them as one


Comment on Re^2: to csv file
Re^3: to csv file
by poj (Priest) on Jun 29, 2013 at 07:52 UTC

    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
    poj
      hey the thing is i need the output as csv , because it is an input to other sub routine
        I would change the other routine, but anyway, a simple solution would be double quote all the fields regardless.
        #!perl use strict; open OUT,">test.csv" or die "$!"; while (<DATA>){ chomp; s/;;/","/g; print OUT '"'.$_.'"'."\n"; } close OUT; __DATA__ abd;;sasa;;trre,dsa;;sdas;;dsss abd;;sasa;;trre,dsa;;sdas;;dsss
        poj

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1041411]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (7)
As of 2015-07-04 14:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls