FieldSeparator Property

Version: Available or changed with runtime version 1.0.

Sets the string that is to be used to separate fields.

Applies to

  • Xml Port

Property Value

Value Description
<None> There is no field separator.
<NewLine> Any combination of CR and LF characters.
<CR/LF> CR followed by LF.
<CR> CR alone.
<LF> LF alone.
<TAB> Tabulator alone.
Other strings The literal string entered.

Syntax

Format = VariableText;
FieldSeparator = '<TAB>';

Remarks

FieldSeparator is only used if the Format property is set to Variable Text. Otherwise, the setting is ignored.

This property specifies how tables should be separated. The default value is a comma (<,>).

The strings in the preceding table must be entered literally, using the < and > characters. These special strings can be combined and can also be mixed with other characters.

CR refers to the character with ASCII value 13.

LF refers to the character with ASCII value 10.

You can set the field separator in AL code so that the XMLport can import and export records with different separators. For example, if your XMLport must import from a file or stream where one record uses commas and another uses TAB, you can change the field separator property at run time.

Properties
Format Property (XMLports)