Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Re: regular expression (search and destroy)

by antirice (Priest)
on Nov 12, 2003 at 23:24 UTC ( [id://306667]=note: print w/replies, xml ) Need Help??


in reply to Re: regular expression (search and destroy)
in thread regular expression (search and destroy)

If I recall correctly, you can have empty fields and the way you actually escape a double quote is as "" instead of \". In other words, these are allowed:

1,"Hello world",,2 2,"""Hello world""",,2

I also believe that if the field contains a double quote, then the entire field must be enclosed in double quotes so escaping rules could apply. There are more rules, but they're mostly allowed values and input record separator issues more than anything else, but that's just for saving and verification that the file you have is really CSV. I think you can read more about them at the end of the documentation here.

Of course, this is only if you want valid CSV or CSV produced by programs such as Excel and whatnot.

Hope this helps.

antirice    
The first rule of Perl club is - use Perl
The
ith rule of Perl club is - follow rule i - 1 for i > 1

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2024-04-20 02:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found