search

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3
https://code.mteixeira.dev/SublimeText-SQLTools/
GNU General Public License v3.0
177 stars 40 forks source link

Export to CSV feature #184

Open javidbu opened 6 years ago

javidbu commented 6 years ago

Issue Type

Feature Request

Description

It would be great if we could export to CSV a query result, with some settings like csv_delimiter, csv_header (true/false), csv_quote_character and things like that. This is super helpful for sharing the result with others, using it in another tool...

Version

MxJ24 commented 6 years ago

use this plugin https://github.com/misfo/Shell-Turtlestein and shell command function tbl2csv() { sed '/^[-+]-.$/d;/^ $/d;s/|/,/g;s/^,//g' $@ }

amohield commented 4 years ago

Having this built in is essential. If you're pulling data using SQL, you almost definitely are going to be manipulating in some way, be it in R, Python, Excel, or something else. So being able to export it to an easily readable, standard format is key.