Bug 103597 - Allow specifying non-printable characters as delimiter in CSV import wizard
Summary: Allow specifying non-printable characters as delimiter in CSV import wizard
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Dialog
  Show dependency treegraph
 
Reported: 2016-10-31 10:06 UTC by AbdulKareem Nalband
Modified: 2018-11-26 12:41 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description AbdulKareem Nalband 2016-10-31 10:06:04 UTC
Description:
Some delimited files generated by machine may be delimited by non-printable charecters such as Ctrl+A , Ctrl+B for either/both fields and rows to avoid complexity in encoding.

CSV import wizard provided a way to specify these characters as delimiters

Steps to Reproduce:
1. Try to open a delimited file with LibreOffice Calc
2. CSV import wizard pops up
3. In separator option un check all but others
4. Try to enter non printable character (tried x01,\u0001 , U+0001)

Actual Results:  
Wizard cannot take non printable character as seperator

Expected Results:
Wizard should provide a mechanism for inputting non-printable characters as separator for both field and row


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:49.0) Gecko/20100101 Firefox/49.0
Comment 1 Heiko Tietze 2016-11-04 11:21:01 UTC
I would rephrase the idea to allow regular expressions as delimiters. Doing so adds a lot of flexibility while the approach is "well known".

https://help.libreoffice.org/Common/List_of_Regular_Expressions
Comment 2 Heiko Tietze 2018-11-26 12:41:51 UTC
Removing needsUX. Still think a hidden feature of regular expression would be sufficient here.