OpenCSVCursor Function

Opens a comma-delimited text file as a RecordSet. The file must use commas to separate fields, returns to separate records, and double quotes ("") to enclose text fields.

Syntax
result = OpenCSVCursor( file )

Parameters
file | FolderItem | FolderItem that refers to the text file.

Return Value
Result | RecordSet | RecordSet containing the rows and columns in the text file.

Commas are permitted within quoted strings. The following record is valid:

22,"Fred","Duesenberg","Engineer"

# Note

OpenCSVCursor requires the CSV Database plug-in. Place this plug-in in the REALbasic Plugins folder. The REALbasic CD includes all database plug-ins and you can always find the most current versions on REAL Software's web site, www.realsoftware.com.

# Example

The following example opens the specified text file.

Dim db as RecordSet
db=OpenCSVCursor( GetFolderItem("table1.txt"))
If db = Nil then
Beep
MsgBox "The database couldn't be opened."
else
//continue with database operations
end if

# See Also

Database, DatabaseField, RecordSet classes; OpenDBFCursor, OpenDTFDatabase functions.