Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

TEXT TO CSV

by Anonymous Monk
on Jun 28, 2013 at 11:09 UTC ( #1041218=perlquestion: print w/replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

how to convert a text file to csv file

Replies are listed 'Best First'.
Re: TEXT TO CSV
by Tux (Abbot) on Jun 28, 2013 at 11:13 UTC

    You are being too vague here.

    • What is the format of the text?
    • Did you search this site for a solution?
    • What have you tried so far?
    • Did you trie readinbg the documentation for Text::CSV and/or Text::CSV_XS already?

    Enjoy, Have FUN! H.Merijn
      hey I saw the code , actually I am new to perl . so from what I see that it is for csv to text , nor the other war around

        the other war around

        Don't mention the war!

        But please do check out Text::CSV which allows you to read and write CSV files.
        ... as brother Tux's pointed out.

        Cheers, Sören

        (hooked on the Perl Programming language)

Re: TEXT TO CSV
by tobyink (Abbot) on Jun 28, 2013 at 11:12 UTC
    while (<>) { chomp; s/"/""/g; print qq["$_",\n]; }
    package Cow { use Moo; has name => (is => 'lazy', default => sub { 'Mooington' }) } say Cow->new->name

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1041218]
Approved by hdb
help
Chatterbox?
[Corion]: hippo: Yes, but I'm not sure that it's even worth the effort of implementing it at all...
[Corion]: You'll only ever need that option if you have a long-running query whose results are not cached by your DB already, and in those cases I presume that the programmer will want to maintain the temporary tables themselves - I wouldn't know when to drop ...
[Corion]: ... the temporary tables, and also don't have a good idea on how to create unique table names for them
[hippo]: OIC. In that case leave it out but invite feature requests and see if any of the users suggest it. :-)
[Corion]: Talking about this makes me realize that it's likely only a half useful idea. But it still would be convenient to have as an option...
[Corion]: hippo: Hmmm - yeah, I could document it and wait for code implementing that option to show up ;-D

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (11)
As of 2017-02-23 15:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (347 votes). Check out past polls.