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
|
<HTML><HEAD>
<TITLE>Tcl API Reference -- ns_getcsv</TITLE>
<LINK rel=Previous href="tapi-c57.htm">
<LINK rel=ToC href="toc.htm">
<LINK rel=Index href="master.htm">
<LINK rel=Next href="tapi-c59.htm">
</HEAD><BODY BGCOLOR="#ffffff"><A NAME="topofpage"></A>
<TABLE WIDTH=100%>
<TR>
<TD ALIGN=LEFT>
<A NAME="topofpage"></A> <IMG SRC="as-c-sm.gif">
</TD>
<TD ALIGN=RIGHT>
<A href="tapi-c57.htm"><IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm> <IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm> <IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="tapi-c59.htm"> <IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<A name="7983"> </A>
</TD>
</TR>
</TABLE>
<a name="199439">
</a><h3>ns_getcsv</h3>
<a name="199440">
</a><h4>Overview</h4>
<p><a name="199441">
</a>Read CSV data from a file</p>
<a name="199442">
</a><h4>Syntax</h4>
<p><a name="199443">
</a><b>ns_getcsv</b> <i>fileId varName</i></p>
<a name="199444">
</a><h4>Description</h4>
<p><a name="199730">
</a><b>ns_getcsv </b>reads one line of CSV data from the specified file and and sets the variable specified by <i>varName</i> to a list of the elements in that row. Any quotes in the line of data are removed. <b>ns_getcsv</b> returns the number of elements in the row.</p>
<p><a name="216510">
</a>If there are no more lines in the file to read, <i>varName</i> does not get set, and <b>ns_getcsv</b> returns -1 as the number of elements in the row.</p>
<p><a name="199752">
</a>A CSV file is an ASCII file containing rows of data in the following syntax:</p>
<ul>
<li>Elements in each row must be separated by commas.<a name="199762">
</a>
<p><li>Each row must end with either \n, \r, or \r\n.<a name="199753">
</a>
<p><li>Elements that contain commas, newlines, or carriage returns can be surrounded by double quotes (e.g., "foo,bar").<a name="199754">
</a>
<p><li>If an element surrounded by double quotes also contains a double quote, you can escape the interior double quote by using two double quotes (e.g., "Evander ""Real Deal"" Holyfield"<a name="199756">
</a>
<p><li>White space that isn't inside double quotes is ignored. For example, the line: 'bob, sarah, mary' will result in the list {bob sarah mary}.<a name="199758">
</a>
<p><li>Null entries are okay, either embedded in the line or at the end of a line. For example, the line: 'bob,,sarah, ' will result in the list: {bob {} sarah {}}.<a name="199760">
</a>
<p></ul>
<TABLE BORDER="2" CELLPADDING="1" width="100%">
<TR><TD COLSPAN=3><P ALIGN=Center>
<IMG SRC="bluebult.gif">
<A HREF="#topofpage">
<FONT SIZE=-1>Top of Page</FONT></A>
<IMG SRC="bluebult.gif">
</TD></TR>
<TR><TD COLSPAN=3><P ALIGN=Center>
<A href="tapi-c57.htm">
<IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm>
<IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm>
<IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="tapi-c59.htm">
<IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<BR align=center>
<FONT size=-1>Copyright © 1998-99 America Online,
Inc.</FONT>
</TD></TR></TABLE></BODY></HTML>
|
