Skip to main content
replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.

Update:

Note that I saw http://stackoverflow.com/questions/10518207/tool-to-convert-csv-data-to-stackoverflow-friendly-text-only-tablehttps://stackoverflow.com/questions/10518207/tool-to-convert-csv-data-to-stackoverflow-friendly-text-only-table , but those are all web site solutions. I'd like something I can run on the command line.

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.

Update:

Note that I saw http://stackoverflow.com/questions/10518207/tool-to-convert-csv-data-to-stackoverflow-friendly-text-only-table , but those are all web site solutions. I'd like something I can run on the command line.

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.

Update:

Note that I saw https://stackoverflow.com/questions/10518207/tool-to-convert-csv-data-to-stackoverflow-friendly-text-only-table , but those are all web site solutions. I'd like something I can run on the command line.

added 236 characters in body
Source Link
David M. Karr
  • 1.2k
  • 1
  • 9
  • 22

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.

Update:

Note that I saw http://stackoverflow.com/questions/10518207/tool-to-convert-csv-data-to-stackoverflow-friendly-text-only-table , but those are all web site solutions. I'd like something I can run on the command line.

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.

Update:

Note that I saw http://stackoverflow.com/questions/10518207/tool-to-convert-csv-data-to-stackoverflow-friendly-text-only-table , but those are all web site solutions. I'd like something I can run on the command line.

Source Link
David M. Karr
  • 1.2k
  • 1
  • 9
  • 22

How to pretty-print CSV/spreadsheet from SQuirreL results?

I'm in a situation where I want to be able to take SQL query results from SQuirreL and paste them as ascii text into various forms and reports. With SQuirreL, I can export results as Excel or a CSV, but I'd like to eventually format the results in something like this format;

+---------+--------+-------+
|  header | header | header|
+---------+--------+-------+
|  value  | value  | value |
+---------+--------+-------+

I would be amazed if this hasn't been done before, but my searches for this have come up empty.