Read CSV

csv reading in extendscript

This scipt asumes that the data.csv is next to the index.js. The content of data.csv is:

num	name	w	f	h
1	A	1	4	2
2	B	2	3	1
3	C	3	2	4
4	D	4	1	3
5	E	3	2	2
6	F	2	3	1

This is the quick and dirty approach. For data you don't know how it is formated I suggest using a library like github.com/Rich-Harris/BabyParse. With minor adjustments it works well in ExtendScript.

/* global File $ */
/* eslint-disable new-cap */
// tested on osx
var file = File(File($.fileName).parent.fsName + '/data.csv'); // get the file
file.encoding = 'UTF8'; // set some encoding
file.lineFeed = 'Macintosh'; // set the linefeeds
file.open('r',undefined,undefined); // read the file
var content = file.read(); // get the text in it
file.close(); // close it again
var lines = content.split('\n');// split the lines (windows should be '\r')
var data = [];// will hold the data
var keys = lines[0].split(','); // get the heads
// loop the data
for(var i = 1; i < lines.length;i++){
  var obj = {}; // temp object
  var cells = lines[i].split(',');// get the cells
  // assign them to the heads
  obj[keys[0]] = cells[0];
  obj[keys[1]] = cells[1];
  obj[keys[2]] = cells[2];
  obj[keys[3]] = cells[3];
  obj[keys[4]] = cells[4];
  data.push(obj); // add to data
  }

$.writeln(data.toSource()); // show what we got

The output is:

[({num:"1", name:"A", w:"1", f:"4", h:"2"}), ({num:"2", name:"B", w:"2", f:"3", h:"1"}), ({num:"3", name:"C", w:"3", f:"2", h:"4"}), ({num:"4", name:"D", w:"4", f:"1", h:"3"}), ({num:"5", name:"E", w:"3", f:"2", h:"2"}), ({num:"6", name:"F", w:"2", f:"3", h:"1"})]