1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
class:: CSVFileReader
summary:: file reader for comma separated data
related:: Classes/File
categories:: Files
description::
CSVFileReader reads comma-separated text files into 2D arrays line by line.
For tab delimited files use link::Classes/TabFileReader::. For semi-colon-delimited files use link::Classes/SemiColonFileReader::. For space-delimited files, or custom delimiters, use link::Classes/FileReader::.
Examples::
code::
(
// write a test file:
f = File("CSVReadTest.sc", "w");
f.write(
"Some,comma,delimited,items, in line 1
and then, some more, with several commas,,,, in line 3
"
);
f.close;
)
// open file, read and put strings into array, close file.
x = CSVFileReader.read("CSVReadTest.sc").postcs;
// can skip empty lines:
x = CSVFileReader.read("CSVReadTest.sc", true).postcs;
// can skip blank entries caused by multiple commas:
x = CSVFileReader.read("CSVReadTest.sc", true, true).postcs;
// do file open/close by hand if you prefer:
f = File("CSVReadTest.sc", "r"); f.isOpen;
t = CSVFileReader(f);
t.read(true, true).postcs;
f.close;
(
// write a test file with numbers:
f = File("CSVReadTestNum.sc", "w");
(1..10).do { |n| f.write(n.asString ++ ","); };
f.close;
)
x = CSVFileReader.read("CSVReadTestNum.sc", true, true).postcs;
x.collect(_.collect(_.interpret)); // convert to numbers.
// or do it immediately:
x = CSVFileReader.readInterpret("CSVReadTestNum.sc").postcs;
(
// write a test file with several lines of numbers:
f = File("CSVReadTestNum.sc", "w");
(1..100).do { |n|
f.write(n.asString ++ if (n % 10 != 0, ",", Char.nl)); };
f.close;
)
x = CSVFileReader.readInterpret("CSVReadTestNum.sc", true, true).postln;
::
|
