Ns getcsv - Revision history

Akhassin at 05:15, 16 October 2009

2009-10-16T05:15:24Z

Akhassin at 05:15, 16 October 2009

2009-10-16T05:15:02Z

Akhassin at 05:14, 16 October 2009

2009-10-16T05:14:39Z

Akhassin at 05:13, 16 October 2009

2009-10-16T05:13:56Z

Akhassin: New page: '''NAME''' : ns_getcsv - Read CSV data from a file '''SYNOPSIS''' : '''ns_getcsv''' ''fp varName'' '''DESCRIPTION''' : '''ns_getcsv''' reads one line of CSV data from the specified fi...

2009-10-16T05:13:14Z

New page: '''NAME''' : ns_getcsv - Read CSV data from a file '''SYNOPSIS''' : '''ns_getcsv''' ''fp varName'' '''DESCRIPTION''' : '''ns_getcsv''' reads one line of CSV data from the specified fi...

New page

'''NAME'''

: ns_getcsv - Read CSV data from a file

'''SYNOPSIS'''

: '''ns_getcsv''' ''fp varName''

'''DESCRIPTION'''

: '''ns_getcsv''' reads one line of CSV data from the specified file pointer (such as returned by the Tcl command open) and sets the variable specified by varName to a list of the elements in that row. Any doule quotes in the line of data are removed. ns_getcsv returns the number of elements in the row.

: If there are no more lines in the file to read, varName does not get set, and ns_getcsv returns -1 as the number of elements in the row.

: A CSV file is an ASCII file containing rows of data in the following syntax:

:* Elements in each row must be separated by commas.

:* Each row must end with either \n, \r, or \r\n.

:* Elements that contain commas must be surrounded by double quotes (e.g., "foo,bar").

:* 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"

:* 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}.

:* 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 {}}.

'''NOTES'''
'''ns_writecsv''' is about 10 times faster than tcllib ::csv::split but currently doesn't support delimiters other than comma and only supports double-quotes, not single-quotes. Neither one properly supports csv files with newlines inside elements

'''SEE ALSO'''

: [[ns_writecsv]]

----

[[Category Documentation]] - [[Category Core Tcl API]]

@@ Line 29: / Line 29: @@
 '''NOTES'''
-:'''ns_writecsv''' is about 10 times faster than tcllib ::csv::split but currently doesn't support delimiters other than comma and only supports double-quotes, not single-quotes.  Neither one properly supports csv files with newlines inside elements
+:'''ns_getcsv''' is about 10 times faster than tcllib ::csv::split but currently doesn't support delimiters other than comma and only supports double-quotes, not single-quotes.  Neither one properly supports csv files with newlines inside elements
 '''SEE ALSO'''

@@ Line 21: / Line 21: @@
 :* Elements that contain commas must be surrounded by double quotes (e.g., "foo,bar").
-:* 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"
+:* 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")
 :* 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}.

@@ Line 9: / Line 9: @@
 '''DESCRIPTION'''
-: '''ns_getcsv''' reads one line of CSV data from the specified file pointer (such as returned by the Tcl command open) and sets the variable specified by varName to a list of the elements in that row. Any doule quotes in the line of data are removed. ns_getcsv returns the number of elements in the row.
+: '''ns_getcsv''' reads one line of CSV data from the specified file pointer (such as returned by the Tcl command open) and sets the variable specified by varName to a list of the elements in that row. Any double quotes in the line of data are removed. ns_getcsv returns the number of elements in the row.
 : If there are no more lines in the file to read, varName does not get set, and ns_getcsv returns -1 as the number of elements in the row.