I am using the command line shell SQLite 3.14.2 2016-09-12. I'm working
with mainframe data in a fixed format.
I would like to use .mode column to create my output text file in a fixed
layout. I set all my column widths using .width. I then output my data to a
file. Unfortunately, there are two blanks separating each column, space I
don't want to be there. The .separator command does not provide any
mechanism for turning it off. Is there a way?
I realize there is a printf function available. However, it appears that
output values must come from a table column, where as below, I could use
case statements in the sql select of the data.
Any suggestions? I think I am overlooking a .separator option that says
"don't put spaces between output columns". I assume that John McKown has
faced this already, given his mainframe pedigree.
Thanks for your time,
"H 0NZOX0001687395 83501 5827 "...
.width 1 15 5 4 2 1 4 4 1 5 1 10 10 10 1 20 20 15 1 10 20 20 50 50 50 50 50
25 2 8 003 006 009
case when piecerate in ('AF','RF') and version_id = '81' then '81' else
segment end as segment,
sqlite-users mailing list