Issue 13878 - CSV import and export should be more flexible, i.e. Calc should treat the delimitter characters "\n" and "\r" differently. Also an "ignore blank lines" option would be useful.
Summary: CSV import and export should be more flexible, i.e. Calc should treat the del...
Status: CLOSED DUPLICATE of issue 834
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.0.2
Hardware: PC Linux, all
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
URL:
Keywords: rfe_eval_ok, third_party_support, usability
Depends on:
Blocks:
 
Reported: 2003-04-27 21:48 UTC by goc
Modified: 2006-05-15 11:49 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description goc 2003-04-27 21:48:43 UTC 
Hello,

I'd like to process foreign CSV data files that have the property of lines
separated with line feeds ("\n"), and which have multiline text fields within
a line where the lines within such a field are separated with a carriage
return ("\r"). It would be nice if OpenOffice could read and write such files
properly instead of ignoring the difference between \n and \r and thus break
the lines. Some more options to the import and export dialogue would be
required. Alternatively, the possibility to specify import and export filters
for files, lines, and cells, would be nice where the filters should be
specifiable as eg. Perl scripts.

Thanks!
Comment 1 frank 2003-04-28 07:11:44 UTC 
Hi Bettina,

1 4 u

Frank
Comment 2 daniel.rentz 2003-04-28 09:24:16 UTC 
The "\n inside fields" seems to be double to issue 7370.
Comment 3 lbc 2004-03-30 21:40:52 UTC 
\n inside fields is a duplicate of 834.
Comment 4 ianp 2004-04-23 09:59:14 UTC 
I'm adding this here rather than as a separate issue since it seems to be related. 

It would be good if there was an "ignore blank lines" option when importing CSV
and related (other delimeters and fixed-width) files.

Cheers,
Ian.
Comment 5 erwin.tenhumberg 2004-10-28 11:34:00 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 6 ooo 2006-05-15 11:48:53 UTC 
Duplicate of another issue that is already solved.

*** This issue has been marked as a duplicate of 834 ***
Comment 7 ooo 2006-05-15 11:49:19 UTC 
Closing.