CSV to SQL

by Vladimir

HTML

<textarea class="input"></textarea><br />
field delimiter <input class="f-del" value="," /><br />
row delimiter <input class="r-del" value="\n" /><br />
<input class="i" type="button" value="Generate" /><br />
<textarea class="output"></textarea>

CSS

textarea {
  width: 90%;
  height: 300px;
}

JavaScript

$('.i').click(function() {
var fDel = $('.f-del').val();
var rDel = $('.r-del').val();
	var inp = $('.input').val();
  var inpArr = inp.split(rDel);
  alert(inpArr.length);
  var fields = inpArr[0].split(fDel);
  var result = [];
  for(var i = 1; i < inpArr.length; i++) {
  	var vals = inpArr[i].split(fDel);
  	result.push("UPDATE wp_posts SET " + fields[1] + "='" + vals[1] + "' WHERE ID=" + vals[0] + ";");
  }
  $('.output').val(result.join('\n'));
});