I'm running a Spectre netlist through the Linux shell, e.g.
$ spectre my_netlist.scs
After running this simulation, I want to access the simulation results database. My questions are:
Spectre doesn't have a "CSV" output format directly. Of course, you could write a VerilogA model that monitors a node and then writes out the changes to a CSV file.
As for writing scripts, you can either use the Spectre Measurement Description Language (in the MMSIM documentation) or OCEAN (in the IC documentation) which provide a batch way of accessing simulation results and post-processing (MDL normally runs during the simulation). There's also a Spectre Toolbox for Matlab (which is also in the documentation) which allows you to directly read simulation results into Matlab.