Does anyone have a script that utilizes a CSV to create text layers?

@willcampbell7 / @Lumigraphics ... or anybody else who can help:

I am hoping that you can help me to make use of your CSV parser...

Let's say I have the following simple table:

Name,Value1,Value2,Value3
Apple,A1,A2,A3
Banana,B1,B2,B3
Cherry,C1,C2,C3

I don't need the first row. And I wish to find out if the Name "Banana" exists. If it does exist, then extract the values to variables from that row – Value1, Value2, Value3 (ignoring the Name).

var value1 = 'B1';
var value2 = 'B2';
var value3 = 'B3';

Even if the entire row matching "Banana" was extracted to a variable, I could use RegEx to isolate the required parts, however, I know there must be a more "pure" way than via regex.

I have managed to make it as far as:

var file = new File("~/Desktop/Test-CSV/test.csv");
file.open("r");
var data = file.read();
file.close();
var dataArray = parseCsv(data);
// Extract header row.
var header = dataArray.shift();

for (var i = 0; i < dataArray.length; i++) {
    
    var Name = dataArray[i][0];
    var Value1 = dataArray[i][1];
    var Value2 = dataArray[i][2];
    var Value3 = dataArray[i][3];

    // Do some process here.

    var theValue = "Banana"; // this would come from a variable, not a string

    if (data.match(theValue)) {
        
        //alert("Banana exists");

        // Mock result that I wish to achieve...
        alert("Banana,B1,B2,B3");
        // Or even better - B1,B2,B3 as separate variables for Value1,Value2,Value3

    } else {
        alert("Banana doesn't exist!");
    }
}

/////

function parseCsv(data, delimiter) {
    // data: String = contents of a CSV file
    // delimiter: character that separates columns
    //            undefined defaults to comma
    // Returns: Array [[String row, String column]]
    var c = ""; // Character at index.
    var d = delimiter || ","; // Default to comma.
    var endIndex = data.length;
    var index = 0;
    var maxIndex = endIndex - 1;
    var q = false; // "Are we in quotes?"
    var result = []; // Array of rows (array of column arrays).
    var row = []; // Array of columns.
    var v = ""; // Column value.
    while (index < endIndex) {
        c = data[index];
        if (q) { // In quotes.
            if (c == "\"") {
                // Found quote; look ahead for another.
                if (index < maxIndex && data[index + 1] == "\"") {
                    // Found another quote means escaped.
                    // Increment and add to column value.
                    index++;
                    v += c;
                } else {
                    // Next character not a quote; last quote not escaped.
                    q = !q; // Toggle "Are we in quotes?"
                }
            } else {
                // Add character to column value.
                v += c;
            }
        } else { // Not in quotes.
            if (c == "\"") {
                // Found quote.
                q = !q; // Toggle "Are we in quotes?"
            } else if (c == "\n" || c == "\r") {
                // Reached end of line.
                // Test for CRLF.
                if (c == "\r" && index < maxIndex) {
                    if (data[index + 1] == "\n") {
                        // Skip trailing newline.
                        index++;
                    }
                }
                // Column and row complete.
                row.push(v);
                v = "";
                // Add row to result if first row or length matches first row.
                if (result.length == 0 || row.length == result[0].length) {
                    result.push(row);
                }
                row = [];
            } else if (c == d) {
                // Found comma; column complete.
                row.push(v);
                v = "";
            } else {
                // Add character to column value.
                v += c;
            }
        }
        if (index == maxIndex) {
            // Reached end of data; flush.
            if (v.length || c == d) {
                row.push(v);
            }
            // Add row to result if length matches first row.
            if (row.length == result[0].length) {
                result.push(row);
            }
            break;
        }
        index++;
    }
    return result;
}

Whether searching for Apple, Banana or Cherry, or another fruit yet to be added to the CSV, the idea is to extract the values to a variable so that the variable can be used elsewhere in the script. Hope this makes sense.

Thank you in advance. I haven't done much work with arrays and I realise that this is hindering things.