Bug 118007 - CSV-like files backslash escapes are imported technically correct, but unworkable - a "accept backslash as an escape" option would be nice.
Summary: CSV-like files backslash escapes are imported technically correct, but unwork...
Status: RESOLVED DUPLICATE of bug 55049
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.3.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-06-05 09:31 UTC by Dr. Nagy Elemér Károly
Modified: 2018-06-22 12:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Test case CSV (80 bytes, text/plain)
2018-06-05 09:32 UTC, Dr. Nagy Elemér Károly 		Details
Screenshot of import unformatted text options. (36.49 KB, image/png)
2018-06-05 11:49 UTC, m_a_riosv 		Details
Expected behaviour (5.31 KB, image/png)
2018-06-05 12:17 UTC, Dr. Nagy Elemér Károly 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dr. Nagy Elemér Károly 2018-06-05 09:31:40 UTC 
Description:
Some programs (e.g. MySQL) escape double quotes with backslashes, ignoring RFC 4180 2/7.
Libreoffice import is working technically correctly on these files, but the result is "broken" for a layman who exports "CSV" and then imports "CSV".
An option to enable backslash-escaped double quotes (simply replace all backslash+double quote with double quote+double quote?) would be verynice.

Steps to Reproduce:
Import this CSV-like file as CSV:
"test1","OK"
"test2","Kinda \" OK"
"test3","Problematic \""
"test4","behaviour"

Actual Results:  
Three lines imported, line 3 has 3 fields.

Expected Results:
Four lines imported, all lines have 2 fields.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36
Comment 1 Dr. Nagy Elemér Károly 2018-06-05 09:32:26 UTC 
Created attachment 142532 [details]
Test case CSV
Comment 2 m_a_riosv 2018-06-05 11:49:57 UTC 
Created attachment 142534 [details]
Screenshot of import unformatted text options.

There is a combination of options, that except a blank first column, seems do it fine. Using also separate by \" and without string delimiter.
Comment 3 Dr. Nagy Elemér Károly 2018-06-05 12:17:38 UTC 
Created attachment 142535 [details]
Expected behaviour
Comment 4 Dr. Nagy Elemér Károly 2018-06-05 12:19:18 UTC 
I attached a screenshot of the expected result. This is what the data looks like in MySQL and it would be nice to get it look the same via CSV export/import.
Comment 5 Buovjaga 2018-06-22 12:20:06 UTC 

*** This bug has been marked as a duplicate of bug 55049 ***