Re:[CSV] The Feature Multiple-Character Delimiter

2020-05-13 Thread Chen Guoping1
At 2020-05-13 22:29:20, "Gary Gregory" wrote: >On Wed, May 13, 2020 at 6:48 AM sebb wrote: > > >Chen, > >Are you talking about record separators, field separators, or both? > >Gary > Hi, all Sorry, field seperators. It is the problem described by [CSV-206](https://issues.apache.org/jira/proj

Re: [CSV] The Feature Multiple-Character Delimiter

2020-05-13 Thread Gary Gregory
On Wed, May 13, 2020 at 6:48 AM sebb wrote: > On Wed, 13 May 2020 at 00:27, Gary Gregory wrote: > > > > Hi, > > > > May you give an example where more than one character is used as a > > separator? Is there a database or known tool out there that uses such a > > format? > > The IBAN Registry (TX

Re:Re: [CSV] The Feature Multiple-Character Delimiter

2020-05-13 Thread Chen Guoping1
Hi, As shown in the following figure, MySQL supports multi character separator import and export: And about [CSV-206](https://issues.apache.org/jira/projects/CSV/issues/CSV-206?filter=allopenissues), StackOverflow (https://stackoverflow.com/questions/8653797/java-csv-parser-with-string-separa

Re: [CSV] The Feature Multiple-Character Delimiter

2020-05-13 Thread sebb
On Wed, 13 May 2020 at 00:27, Gary Gregory wrote: > > Hi, > > May you give an example where more than one character is used as a > separator? Is there a database or known tool out there that uses such a > format? The IBAN Registry (TXT) located at: https://www.swift.com/standards/data-standards/i

Re: [CSV] The Feature Multiple-Character Delimiter

2020-05-12 Thread Gary Gregory
Hi, May you give an example where more than one character is used as a separator? Is there a database or known tool out there that uses such a format? WRT escaping I would think that \ escapes the one character that follows only. It is up to the reader to decide what to do with an escape sequence

[CSV] The Feature Multiple-Character Delimiter

2020-05-12 Thread Chen Guoping1
Hi, all In CSV parsing, there are many scenarios where multiple characters are used as separators, To support this feature, we should change the char type of delimiter to String. This will lead to API changes, and old usage code may need to be modified to pass. When parsing we can ge