Zoomed Image

AMSX Scripting Language - Command : xmltocsv

Summary

Convert the current XML document to a delimited text string

Description

Serialises all records in the mdoc XML buffer as delimited text into the result buffer. By default uses comma as the separator. Optionally adds a header row from field names, wraps values in double quotes, and removes the trailing separator from each row. Note: removing the trailing separator can break AD integration which relies on it.

Parameters

ParameterDescription
cmdColumn separator character, or "tab" for tab-delimited (defaults to comma)
Argument 0"1" to include a header row with field names
Argument 1"quote" to wrap each field value in double quotes
Argument 2Ignored
Argument 3"1" to remove the trailing separator after the last field on each row

Syntax


XmlToCSV "Column separator character, or "tab" for tab-delimited (defaults to comma)", ""1" to include a header row with field names", ""quote" to wrap each field value in double quotes", "Ignored", ""1" to remove the trailing separator after the last field on each row"

Return to the AMSX Command Reference