FieldEndDelimiter Property

Microsoft Dynamics Nav 2009

Sets the string that is to be used to mark the end of a field.

Dataports

Value Description

<None>

There is no FieldEndDelimiter

<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

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.

The default is value is a quote (<">).

CR refers to the character with ASCII value 13.

LF refers to the character with ASCII value 10.

FieldEndDelimiter is only used if FileFormat Property is set to Variable. Otherwise, the setting is ignored.

The string defined as FieldEndDelimiter is used in addition to the string defined as FieldSeparator Property. The intended use is when the fields include characters that are themselves delimiters. If it is not necessary to use FieldEndDelimiter for this purpose, set it to a value of <None>.

When importing, the delimiters can be present in the file. The following example shows what would happen if FieldStartDelimiter and FieldEndDelimiter are equal to " and FieldSeparator is equal to ,.

a,"b",c,"text with comma,",d

The result would be broken into fields like this:

a

b

c

text with comma,

d

Community Additions

ADD
Show: