To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85946 Issue #|85946 Summary|CSV import - auto-detect delimiters Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|open-import Assigned to|spreadsheet Reported by|fabianvss
------- Additional comments from [EMAIL PROTECTED] Thu Feb 7 17:00:46 +0000 2008 ------- The text import dialog which appears when opening a CSV file, should analyze the text and automatically select most likely delimiter options. By default, a semicolon is selected for separating fields and a double quote for text. But often, f.e. in regions where decimal separators are commas instead of dots, semicolons are used for separating the fields and it is very annoying to change this every time when opening a file. It should do the following: - search for one tabulator - if found then use tabulators as field delimiter - else - count all commas and semicolons - if semicolons > commas then use semicolons as field delimiter - else use commas as field delimiter Now, just counting text delimiters isn't sufficient as the following example of a CSV row shows: I'm here,I'm there,"I'm nowhere, but aware" - count all double and single quote pairs around fields (field delimiter or start of line on the left, and field delimiter or end of line on the right) (a raw search could lead initiating the complex search when 2 occurences are found, otherwise the number of pairs is treated as 0) - if single quote pairs > double quote pairs then use single quotes as text delimiter - else use double quotes as text delimiter --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
