[PLUG] Exporting SQLite to CSV (or hints on searching the web ; )
Richard Owlett
rowlett at cloud85.net
Sun Aug 5 02:48:15 UTC 2018
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
More information about the PLUG
mailing list