[Libreoffice-bugs] [Bug 53325] New: FILEOPEN "CSV" import not correctly recognizing space and text field delimiters, i.e. web log file

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Fri Aug 10 10:29:43 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=53325

             Bug #: 53325
           Summary: FILEOPEN "CSV" import not correctly recognizing space
                    and text field delimiters, i.e. web log file
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.6.0.4 release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: sean.carlos at gmail.com


Apache web server log files contain text data separated by spaces; data fields
containing spaces is enclosed in double quotes.

LibreOffice 3.4.x properly parses this data, 3.6.0.4 does not seem to want to
do so: it only sees the first and last double quotes and dumps everything in
between into one column instead of splitting it across columns.

I don't know about 3.5.x nor have I tried to confirm this on other platforms.

Example data line (w/o wrapping!)

66.249.73.206 - - [10/Aug/2012:10:03:45 +0200] "GET
/news/tema/anteprima-istantanea HTTP/1.1" 500 7055 "-" "Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list