@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
|
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.
13
Replies
AdChoices
