Thanks to both of you.
I now have desired data in CSV format.
However, Mr. Murphy intruded.
CherryTree manual gives explicit description of importing CSV data.
BUT, the menu item does not exist.
A major milestone has been accomplished I know:
the "shape" of my underlying data
only 3 of 12 fields are required for my goal
SQLite can export tcl lists - not a tcl expert but am learning
worst come to worst case, Dartmouth BASIC can handle my needs,
if not my wishes ;/
Now for 10PM news and SLEEP
Thanks
On 08/04/2018 06:28 PM, Tomas K wrote:
I'd imagine that your sqlite3 DB will have multiple tables and some
schema to guide you.
Use: .tables to see what tables you have
.schema tableName to see the schema for each table
When you pick the tableName, you can get .csv of the table with
tableName this way:
sqlite3 -header -csv sqliteDbFile "select * from tableName;" >
tableName.csv
Tomas
On Sat, 2018-08-04 at 15:06 -0700, Rich Shepard wrote:
On Sat, 4 Aug 2018, Richard Owlett wrote:
I've some SQLite files (internal to SeaMonkey) which I wish to
examine. If
I can convert to CSV any spreadsheet program will allow me to
delete
irrelavant columns. Then export to CSV and import to Cherrytree for
manipulation.
Start sqlite3 <filename>. At the prompt use .help for all help and
use
.mode csv to look at the data in that format. You can also .save the
in-memory file to disk.
HTH,
Rich
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
