Salesforce

Variable Delimiting Method (Dlm) - Form Input Operation (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Variable Delimiting Method (Dlm) - Form Input Operation (Magic xpa 4.x)

The Variable Delimiting Method (Dlm) property defines how the variables of the input record are delimited. The possible values are:

Column – This is the default. When C is specified, the input variables are located in fixed columns without delimiter characters. The Form used in the operation must match this layout exactly, including the spaces between the variables in the record.
When you specify Column, the Chr property is irrelevant and the insertion point skips it.

Single – When Single is specified, the variables in the input record are separated by a single delimiter, added after (to the right side of) each input data item. For example, in the input record:

"123, ABCDE, -23.57", the character Comma (,) is used as the delimiter and you will have to specify it in the Char property.

When you specify Single, the spacing between variables in the Form is not significant.

Double – When Double is specified, the variables in the input record are separated by a double delimiter, one added before and one added after (to the left and right sides of) each input data item. For example, in the input record "123" "ABCDE" "- 23.57", the character Quote (") is used as the delimiter and it is specified as such in the Chr property.

When you specify Double, the spaces between the variables in the file record and those between the variables in the Form are not relevant.

The Form Input operation with a single delimiter automatically strips leading and trailing double quotes from variables of the input file. For example, the following input

"A", "B", "C"

when read with the Form Input operation using ',' (comma) as the single delimiter character, will read the values A, B, and C, not "A", "B", "C", into the corresponding Magic xpa variables.

Reference
Attachment 
Attachment