Help Needed: Trouble Filtering and Re-Entering Data

Re:

• The UUID (last line) must be unique—no duplicate entries allowed.

$query = "
CREATE TABLE IF NOT EXISTS myList (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    Name TEXT NOT NULL,
    UUID TEXT NOT NULL UNIQUE
);
";

DDL key words unique.

Re:

The idea is to paste multi-line text into a text field.

regular expression.

var text = document.getElementById('inputText').value;

            var nameRegex = /(\d+g Name Bundle sib \d+ \d+[A-Z]*)/;

            var uuidRegex = /([a-f0-9-]{36})/;

            var nameMatch = text.match(nameRegex);

            var uuidMatch = text.match(uuidRegex);