Csvread()
Reads a CSV separated block and transform it to a Query object
Usage
QUERY = Csvread(
string,
headerline,
delimiter,
qualifier
)
Argument | Summary |
---|---|
string | string |
headerline | header first line - does the first contain the column names - default false [optional] |
delimiter | delimiter - default comma (,) [optional] |
qualifier | qualifier - default double quote (") [optional] |
Calling
Supports named-parameter calling allowing you to use the function like:
Csvread( string=?, headerline=?, delimiter=?, qualifier=? );
Supports passing parameters as a structure using ArgumentCollection:
Csvread( ArgumentCollection={ string : ?, headerline : ?, delimiter : ?, qualifier : ? } );
See Also
Csvread
Csvwrite
Datasourcecreate
Datasourcedelete
Datasourceinfo
Datasourceisvalid
Dbinfo
QueryAddcolumn
QueryAddrow
QueryColumnarray
QueryColumnlist
QueryDeletecolumn
QueryDeleterow
QueryEach
QueryIsempty
QueryNew
QueryOfqueryrun
QueryRenamecolumn
QueryRequestmetrics
QueryRowstruct
QueryRun
QuerySetcell
QuerySort
QueryToarray
Quotedvaluelist
ToHtml
Valuelist