Cousin Stanley wrote:
>> regarding your sqlrpt program ....
>>
>> Can the floating point numbers be formatted
>> for example .... ah la .... %8.4f
James K. Lowden wrote:
> Cousin Stanley,
>
> Indeed you now can.
>
> I added a -p option, documented in the man page.
>
> You supply the column name & printf format string
> you want to use for it.
>
> It works for numbers only: integers and floating point.
>
> Strings continue to be formatted by tbl & troff.
James ....
Thanks for providing the sqlrpt program
and adding the format option.
I very much appreciate your time and effort.
However, I'm not sure I have installed the newer version
correctly as I don't speak Makefile and couldn't manage
the make step until lines 13, 15, and 19 from the Makefile
were commented out ....
e.g. lines with ..... <<<< ====== >>>>
Using make then make install in this manner
did provide a working sqlrpt executable
that worked as you describe to format
a single numeric column from an sql query ....
$ sqlrpt .... -p "Value,%'8.2f" ....
I haven't tried repeating -p options yet
for formatting multiple columns ....
--
Stanley C. Kitching
Human Being
Phoenix, Arizona
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
