// Copyright by Mathias Mamsch, 2010 /* csv read */ Buffer readFileToBuffer (string fn) { Stream st = read binary fn Buffer temp = create() Buffer result = create() while (true) { st >> temp if (end st) break result += temp } delete temp return result } void getToken (Buffer b, Buffer token, int &pos, int max, bool &newLine) { setempty token bool inQuote = false newLine = false while (pos < max) { if (b[pos] == '"') { if (!inQuote) { inQuote = true; pos++; continue } if (inQuote && b[pos+1] == '"') { pos++ } else { inQuote = false; pos++; continue } } else { if (b[pos] == ',' && !inQuote) {pos++; break; } if ((b[pos] == '\n' || b[pos] == '\r') && !inQuote) {pos++; newLine = true; break; } } token += b[pos] pos++ } } Skip readRecord (Buffer b, int &pos, int len) { Skip sk = create() int nr = 0; bool eol = false Buffer token = create() if (pos >= len) return null Skip while (!eol && pos < len) { getToken (b, token, pos, len, eol); put(sk, nr++, stringOf token) } return sk } Buffer b = create() b = "1997,Ford,E350,\"ac, abs, moon\",3000.00 1999,Chevy,\"Venture \"\"Extended Edition\"\"\",\"\",4900.00 1999,Chevy,\"Venture \"\"Extended Edition, Very Large\"\"\",\"\",5000.00 1996,Jeep,Grand Cherokee,\"MUST SELL! air, moon roof, loaded\",4799.00 " // " // Buffer b = readFileToBuffer "C:\\Mappe1.csv" Buffer token = create() int pos = 0; int len = length b bool eol = false string s while (true) { Skip sk = readRecord(b, pos, len) if (null sk) { print "EOF"; break } print "Record:" for s in sk do { print "COL: " ((key sk) int) " -> " s " | " } print "\n" delete sk } }