Specify Delimiters

Delimiter

A character that Horizon uses to distinguish between columns of a borrower record.

You can specify what delimiters you want to use by entering them in your header. You must put a delimiter after every column unless the column is a fixed field, then no delimiter is necessary.

You may use a return as a delimiter at the end of a line. (For an exact definition of a return, see Syntax Diagrams for Borrower Import Formats

 

Possible Column Delimiters

,

;

=

!

:

<

>

*

$

%

+

_

^

?

~

&

|

\

/

 

Avoid using a delimiter that is also in the text of a column. Otherwise Borrower Import will split the information into different columns.

Here is an example of what to avoid:

Action_code, name, second_id, is a valid header that uses commas as delimiters. However, if the data file is A, Marie, Lana Y., 555-55-5555, then Marie and Lana Y., which are both part of the name, will be split into separate columns.

The easiest way to avoid this is to use a different delimiter, such as a semicolon instead of a comma. The same heading with semicolons as the delimiters creates a data file like this one:

A; Marie, Lana Y.; 555-55-5555.

 


© 1998-2017 Sirsi Corporation