Bugs item #2821456, was opened at 2009-07-14 19:41 Message generated for change (Comment added) made by sjoerd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2821456&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Mapi Group: Clients CVS Head >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) Summary: Strange " escaping in -f csv Initial Comment: select 'bla'; bla select '"'||'bla'; "\"bla" Now what would be the way to get my string just surrounded by " "? ---------------------------------------------------------------------- >Comment By: Sjoerd Mullender (sjoerd) Date: 2009-07-14 20:30 Message: The CSV formatter is pretty primitive, but it does the job. The renderer does not look at the type of the columns, only at the content of the fields. If a value contains the separator (i.e. comma or tab, depending on the mode) or if it contains a newline or a double quote, it will surround the value with double quotes, otherwise it won't. This should be enough for most purposes (although I can imagine that any white space should trigger the quotes). As far as I know, there is no "standard" for CSV data (i.e. there are various variations). If you know of a standard, please let us know. I'm closing this as Invalid, but feel free to open a Feature Request. If you do, please be clear in what *exactly* you would like to see changed so that we don't have to do any second guessing. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2821456&group_id=56967 ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
