Convert Text Lines to CSV or Vice Versa
by Hendy T
HTML
<h2>Convert Text Lines to CSV</h2>
<textarea rows="8" cols="50" id="input-box" spellcheck="false"></textarea>
<br />
<button id="btn-convert" type="button">Convert!</button>
<br /><br />
<h2>Convert CSV to Text Lines</h2>
<textarea rows="8" cols="50" id="input-box2" spellcheck="false"></textarea>
<br />
<button id="btn-convert2" type="button">Convert!</button>
JavaScript
$('#btn-convert').click(function() {
var text = $('#input-box').val();
text = text.replace(/^/gm, "'").replace(/$/gm, "'").replace(/$(\r\n|\r|\n)/gm, ", ");
$('#input-box').val(text);
});
$('#btn-convert2').click(function() {
var text = $('#input-box2').val();
text = text.replace(/^'/g, "").replace(/'$/g, "").replace(/', '/g, "\r\n");
$('#input-box2').val(text);
});