The collectCvsLines token parses a line in a comma-separated values (CSV) file. The collectCvsHeader token must have been previously invoked.
The Scripted Gateway adapter and Shell Script adapter, among others, can use this token. The collectCsvHeader and collectCsvLines tokens are the only tokens that the Scripted Gateway adapter can use.
If any of the following attributes are not specified, then the value is inherited from the previously-issued collectCsvHeader token.
Attribute |
Description |
---|---|
idHeader |
Specifies which value is considered the account ID. |
nameHeader |
Specifies which value is considered the name for the account. |
delim |
Optional. The string that separates values in the header. The default value is , (comma). |
trim |
Optional. If set to true, then if a value has leading or trailing blanks, remove them. The default is false. |
unQuote |
Optional. If set to true, then if a value is enclosed in quotes, remove them. The default is false. |
None
The following example removes white space and quotation marks from values.
<collectCsvLines trim=’yes’ unQuote=’yes’/>