The column name "EMPLOYEE_ID" is invalid. Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and underscores.

colName

colName

"EMPLOYEE_ID"

function csvToQuery(csvString) {

var rowDelim = chr(10); // Default line break

var colDelim = ",";     // Default column separator

var newQuery = QueryNew("");

var columnNames = [];

var rows = [];

var i = 1;

var j = 1;

csvString = trim(csvString);

// Optional rowDelim and colDelim overrides

if (arrayLen(arguments) >= 2) rowDelim = arguments[2];

if (arrayLen(arguments) >= 3) colDelim = arguments[3];

// Split into rows

rows = listToArray(csvString, rowDelim);

// Parse header row and create columns

var headers = listToArray(rows[1], colDelim);

for (i = 1; i <= arrayLen(headers); i++) {

columnNames[i] = trim(uCase(replace(headers[i], " ", "_", "all")));

queryAddColumn(newQuery, columnNames[i], []);

}

// Parse and add remaining rows

for (i = 2; i <= arrayLen(rows); i++) {

var rowData = listToArray(rows[i], colDelim);

queryAddRow(newQuery);

for (j = 1; j <= arrayLen(columnNames); j++) {

if (j <= arrayLen(rowData)) {

var cellValue = trim(replace(rowData[j], chr(34), "", "all"));

querySetCell(newQuery, columnNames[j], cellValue, i - 1);

}

}

}

return newQuery;

}