Reading a comma-delimited (csv) file in ax dynamics

Question

How do you open and parse a csv file in ax dynamics?

Answer 1

static void TestCommaTextIO(Args _args) { #File CommaTextIo commaTextIo; FileIOPermission permission; container containFromRead; int x; int cols; ; permission = new FileIOPermission('c:\\junk\\mycsv.csv',#io_read); permission.assert(); commaTextIo = new CommaTextIO('c:\\junk\\mycsv.csv','R'); containFromRead = commaTextIo.read(); While(containFromRead) { cols = conLen(containFromRead); for(x=1;x<=cols;x++) { print conpeek(containFromRead,x); } containFromRead = commaTextIo.read(); } pause; commaTextIo = null; }