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