Csvwrite()
Transforms the query object into a Comma Separated Value (CSV) block
Usage
STRING = Csvwrite(
query,
headerline,
delimiter,
lineDelimiter
)
Argument | Summary |
---|---|
query | query |
headerline | header first line - contain the column names - default true [optional] |
delimiter | delimiter - default comma (,) - use 'tab' string for tabs [optional] |
lineDelimiter | line delimiter - default CRLF (\r\n) [optional] |
Calling
Supports named-parameter calling allowing you to use the function like:
Csvwrite( query=?, headerline=?, delimiter=?, lineDelimiter=? );
Supports passing parameters as a structure using ArgumentCollection:
Csvwrite( ArgumentCollection={ query : ?, headerline : ?, delimiter : ?, lineDelimiter : ? } );
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