JSFiddle - React, Tailwind, and code Playground

by Daedalus

HTML

<textarea id="inpt"></textarea>
<textarea id="outpt"></textarea>

CSS

#outpt {
    width: 100%;
    height: 600px;
}

JavaScript

$(function () {
    $("#inpt").blur(function () {
        var $this = $(this);
        var lines = $this.val().split("\n\n");
        var skill_data = [];
        $.each(lines,function(i,skill) {
            var skill_arr = skill.split("\n");
            var skill_name = skill_arr[0];
            var skill_stats = skill_arr[1].split("Statistic: ")[1]
            var skill_stat1 = skill_stats.split(" / ")[0];
            var skill_stat2 = skill_stats.split(" / ")[1];
            skill_data.push([skill_name,skill_stat1,skill_stat2]);
        });
        var header = "INSERT INTO `skills` (`id`, `name`, `base`, `custom`) VALUES ";
        $.each(skill_data,function(i,data) {
            var skill_stat = (typeof data[2] !== 'undefined')?'["'+data[1]+'","'+data[2]+'"]':data[1];
            header += "(NULL,'"+data[0]+"','"+skill_stat+"',NULL),\n";
        });
        $("#outpt").val(header.replace(/,\n$/,''));
    });
});