Thanks John. I had a feeling you would have encountered this sort of stuff.
And thanks for your time, Simon. All is appreciated. And thanks in advance, Dr. Hipp, if you act on this...allowing a \0 row separator in column mode. It would simplify the life of us mainframers. dvn On Thu, Oct 13, 2016 at 3:31 PM, John McKown <john.archie.mck...@gmail.com> wrote: > On Thu, Oct 13, 2016 at 2:42 PM, Don V Nielsen <donvniel...@gmail.com> > wrote: > > > Thanks, but it appears that ".mode column" triggers it, and .separator > does > > not appear to have any influence in that mode. > > > > Out of curiosity, it appears that the row separator (in windows) is a > > single character. Do you know to specify as the row separator? > Everything > > I attempt is taken as literal characters. I've attempted: 0x0D0x0A, > > 0x0D0A, 0Dx0Ax. Nothing appears to work. > > > > The row separator is specified using the 2nd parameter of the .separator > command. Example transcript: > > > SQLite version 3.11.0 2016-02-15 17:29:24 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> .mode column > sqlite> .separator | - > sqlite> create table a(one text,two text); > sqlite> .width 10 10 > sqlite> insert into a values('1a','2a'); > sqlite> insert into a values('1b','2b'); > sqlite> select * from a; > 1a 2a -1b 2b -sqlite> > > Note that the specified column separator is ignored in .mode column, but > the row separator is not. Also, for fun, note what happens with negative > widths > > sqlite> .width -10 -10 > sqlite> select * from a; > 1a 2a- 1b 2b-sqlite> > > Also, I have looked at the current sqlite3.c source code. In .mode column, > the space separator character is "hard coded" and so cannot be set to any > other character. > > Lastly, you can specify a "control" character by using a C language escape. > E.g. (continuing from above examples) > > sqlite> .separator - \n > sqlite> select * from a; > 1a 2a > 1b 2b > > To address your desire, it would be necessary for the column separator > character to be honored in .mode column mode and the separator be made a > 0x00, or \0. If Dr. Hipp were to do this, this would eliminate the column > separator entirely because \0 would result in "no" character between the > columns. This appears, to me, to be a rather simple change in shell.c. > > > > dvn > > > > > > -- > Heisenberg may have been here. > > Unicode: http://xkcd.com/1726/ > > Maranatha! <>< > John McKown > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users