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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
###############################################################################
# BRLTTY - A background process providing access to the console screen (when in
# text mode) for a blind person using a refreshable braille display.
#
# Copyright (C) 1995-2025 by The BRLTTY Developers.
#
# BRLTTY comes with ABSOLUTELY NO WARRANTY.
#
# This is free software, placed under the terms of the
# GNU Lesser General Public License, as published by the Free Software
# Foundation; either version 2.1 of the License, or (at your option) any
# later version. Please see the file LICENSE-LGPL for details.
#
# Web Page: http://brltty.app/
#
# This software is maintained by Dave Mielke <dave@mielke.cc>.
###############################################################################
proc csvNormalizeRow {columns width} {
if {[set count [llength $columns]] > $width} {
set columns [lrange $columns 0 $width-1]
} elseif {$count < $width} {
lvarcat columns [lrepeat [expr {$width - $count}] ""]
}
return $columns
}
proc csvNormalizeRows {rows width} {
set result [list]
foreach columns $rows {
lappend result [csvNormalizeRow $columns $width]
}
return $result
}
proc csvQuoteText {text} {
return "\"[regsub -all {(")} $text {\1\1}]\""
}
proc csvMakeLine {columns} {
return [join [lmap cell $columns {csvQuoteText $cell}] ,]
}
proc csvMakeTable {rows} {
set table ""
foreach columns $rows {
append table [csvMakeLine $columns]
append table "\n"
}
return $table
}
proc csvApplyHeaders {table} {
set rows [list]
set headers [lindex $table 0]
foreach columns [lrange $table 1 end] {
set row [dict create]
set count [llength $columns]
set index 0
foreach header $headers {
if {$index == $count} {
set column ""
} else {
set column [lindex $columns $index]
incr index
}
dict set row $header $column
}
lappend rows $row
}
return $rows
}
proc csvParseString {string} {
set rows [list]
set columns [list]
set column ""
set finishColumn {
lappend columns $column
set column ""
}
set finishRow {
if {([llength $columns] > 0) || ([string length $column] > 0)} {
eval $finishColumn
lappend rows $columns
set columns [list]
}
}
set state unquoted
set length [string length $string]
set index 0
while {$index < $length} {
set character [string index $string $index]
set isQuote [string equal $character {"}]
incr index
switch -exact $state {
unquoted {
if {$isQuote} {
set state inQuotes
continue
}
switch -exact $character {
"," {
eval $finishColumn
continue
}
"\n" {
eval $finishRow
continue
}
"\r" {
eval $finishRow
set state wasCarriageReturn
continue
}
}
}
inQuotes {
if {$isQuote} {
set state wasQuote
continue
}
}
wasQuote {
if {!$isQuote} {
set state unquoted
incr index -1
continue
}
set state inQuotes
}
wasCarriageReturn {
if {[string equal $character "\n"]} {
set state unquoted
continue
}
}
default {
return -code error "unrecognized csv parse state: $state"
}
}
append column $character
}
eval $finishRow
return $rows
}
proc csvLoadFile {file} {
return [csvApplyHeaders [csvParseString [readFile $file]]]
}
|
