[General]

 

Top  Previous  Next

 

This section contains the EndOfLineChars keyword.  It may also contain the version number of the program which created the file.

 

Keyword


EndOfLineChars

This value is used to describe what sequence of characters is used to delimit records in the import file.  Most DOS and Windows based systems use a "carriage return / line feed" sequence.  If this is what your file uses, just set the value to 0.  That is the default.  Other possible values are: Value: Meaning:

0: Auto detect

1: Carriage return only.  ASCII 13 (0Dh)

2: Carriage return / line feed.ASCII 13 (0Dh) / ASCII  10 (0Ah).

3: Line feed only.  ASCII 10 (0Ah)

DelimChar

  This value is optional.  It will default to a comma.  In most cases this will work just fine.  However, if the data format is delimited with a character other than a comma, this field may be added/modified.  Some common values are listed below:

Value: Delimiter:

9: (tab)

35: #

44: ,

45: -

46: .

59: ;

  QuoteChar

  This value is optional.  It will default to quote marks.  (")  In most cases this will work just fine.  However, if the data format uses a value other than quotes for surrounding text fields, it must be specified here.  Some common values are listed below:

Value:

34: "

39: '