Monday, October 20, 2014

Turn JSON into a SQL Table

One of the new features introduced in the latest version of ClipTable is the ability to parse (most) JSON data (as long as it can be converted to tabular format).

While ClipTable's main purpose is to turn any textual data into a SQL Table (either from your clipboard or a flat file) - we've made two 'other' formats it can read. The first was xml, and now, quite naturally - JSON.

Want to see how it works? Here's a quick example:

Run ClipTable

Copy this following (JSON) text to your clipboard:

[
 {
  color: "red",
  value: "#f00"
 },
 {
  color: "green",
  value: "#0f0"
 },
 {
  color: "blue",
  value: "#00f"
 },
 {
  color: "cyan",
  value: "#0ff"
 },
 {
  color: "magenta",
  value: "#f0f"
 },
 {
  color: "yellow",
  value: "#ff0"
 },
 {
  color: "black",
  value: "#000"
 }
]

Now, Paste!

You should be getting this:



And if you don't know ClipTable yet - the distance between this point to actually having a SQL Table with the above data is about two clicks away.


Feel free to try, and challenge with other tabular clipboard content.

ClipTable - Data import made easy! (Real easy!)