|Perl Monk, Perl Meditation|
Re^3: CSV fileby Polyglot (Pilgrim)
|on May 20, 2009 at 15:54 UTC||Need Help??|
For the record there is currently no such thing as a standard CSV format.
If you are using Microsoft Excel, it will encapsulate each "cell" of data in quotes, instead of escaping the commas. However, what if the cells have quote marks? I suppose they would need to be escaped if using that format. I found the following "guide" to CSV online.
Considerations When Exporting CSV
Is it worth reducing your application's functionality or convenience? No. But if the existence of these characters is entirely superfluous, you might consider taking them out.
Take your pick. I picked one format. There are others.