Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-05 Thread Keith Medcalf
On Tuesday, 4 February, 2020 22:31, Keith Medcalf wrote: The vsv.c (source) file line counting is now verified and I have added a skip= parameter. Adding skip was far easier than variable separators ... Same location, file updated: http://www.dessus.com/files/vsv.c The complete collection:

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-04 Thread Keith Medcalf
On Tuesday, 4 February, 2020 05:19, Robert M. Münch wrote: >On 3 Dec 2019, at 16:10, Jannick wrote: >> would it be possible to add to the csv extension the following >> parameter options (with syntax along the lines of): >> - sep=';': field separator character (different from default ',') >>

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-04 Thread Robert Hairgrove
On 04.02.20 15:42, Simon Slavin wrote: On 4 Feb 2020, at 12:18pm, Robert M. Münch wrote: - sep=';': field separator character (different from default ',') If you provide this facility, please don't add it to anything called 'csv' since the 'c' stands for 'comma'. For those playing along at

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-04 Thread Simon Slavin
On 4 Feb 2020, at 12:18pm, Robert M. Münch wrote: > - sep=';': field separator character (different from default ',') If you provide this facility, please don't add it to anything called 'csv' since the 'c' stands for 'comma'. For those playing along at home, csv files using semi-colon are a

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-04 Thread Kees Nuyt
On Tue, 04 Feb 2020 13:18:30 +0100, you wrote: >On 3 Dec 2019, at 16:10, Jannick wrote: > >> would it be possible to add to the csv extension the following parameter >> options (with syntax along the lines of): >> >> - sep=';': field separator character (different from default ',') >> - skip=N:

Re: [sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2020-02-04 Thread Robert M. Münch
On 3 Dec 2019, at 16:10, Jannick wrote: > would it be possible to add to the csv extension the following parameter > options (with syntax along the lines of): > > - sep=';': field separator character (different from default ',') > - skip=N: skip the first N lines > > Both options would be very

[sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

2019-12-04 Thread Jannick
Hi everyone, would it be possible to add to the csv extension the following parameter options (with syntax along the lines of): - sep=';': field separator character (different from default ',') - skip=N: skip the first N lines Both options would be very helpful for information of fixed format