I need to remove some redundant '\ n from the end of the imported csv before it divides the lines into an array (otherwise I get extra empty lines).
public function parseCSV(data:String):Array {
var lines : Array = data.split ( /\R/ );
var preamble : Array = lines.splice(0,trashLength);
var keyArray : Array = lines.splice ( 0, 1 )[0].split ( "," );
var assocArray : Array = [];
for each (var line:String in lines)
{
var valArray : Array = line.split ( "," );
var assoc : Object = {};
for (var i : int = 0; i < keyArray.length; i++)
{
var key : String = keyArray[i];
if (key != null && key != "") assoc[key] = valArray[i];
}
assocArray.push ( assoc );
}
return assocArray;
}
source
share