Bug 103597

Summary:	Allow specifying non-printable characters as delimiter in CSV import wizard
Product:	LibreOffice	Reporter:	AbdulKareem Nalband <abdulkareem.sn15>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	abdulkareem.sn15, aron.budea, heiko.tietze
Priority:	medium
Version:	5.2.0.4 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	109239

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.