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?? |
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:
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
In Section
Seekers of Perl Wisdom
|
|