exportCsv

The exportCsv function is typically used to export or convert data into formats for non-Analytic Information Server applications. The native exportCsv makes no assumptions of the format of the foreign data (it may have header records or not, it may have trailer records or not, the output fields may be comma-delimited, or comma-delimited, or have no fields at all). The Lambda specified as the anLambda argument is the Lambda handles the formatting and editing details and passes the record to exportCsv. The exportCsv function receives the pre-formatted text record and simply writes it out to a file. In order for the exportCsv function to work properly, the anLambda argument is required to have a child Lambda named refExport(row):.

refExport ChildLambda

The result file from the exportCsv function is a text file. The optional argument, recordVectors:, is useful when the desired result file consists of records consisting of comma-delimited fields. When recordVectors: is specified, the Lambda will pass an aggregate data container such as a Vector, Structure, or Dictionary to the exportCsv function. The exportCsv function will extract each item from the Vector, Structure, or Dictionary and convert each item into text and enter it in a record, separating each data item with a #\, character. The second optional argument, recordsOnly, requires that the Lambda perform the formatting and text conversion. If recordsOnly is specified, the exportCsv function will call the Lambda's refExport and will expect a single text record and will simply write out the record.