What is a field delimiter?
A delimiter is a character that marks the beginning or end of a unit of data. A delimited field is a variable-length field where the field length is set based on the field's contents.
Commonly used delimiters in export files include the comma (,), semicolon (;), and colon (:).
In this example, the field delimiter is a comma (,). See how the comma (,) marks the end of the transaction number, name, service address, and so on.
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
What is a tracked field?
A tracked field is a field the system is actively monitoring. When a field is tracked the system will create a log file that records when, what, and who made changes to the field content. Some fields contain sensitive information that may change the ...What is a surround character?
A surround character is similar to a field delimiter but unlike a field delimiter, the surround character marks the beginning and end of a text field in an export file. The general rule of thumb for choosing the surround character is to pick a symbol ...What is a surround character?
A surround character is similar to a field delimiter but unlike a field delimiter, the surround character marks the beginning and end of a text field in an export file. The general rule of thumb for choosing the surround character is to pick a symbol ...Can I track changes to a field?
There are three different types of history tracking. History tracking logs every change that happens to a field and records the log file in the Notes section. Anyone who has access to the Notes section will also have access to changes to the field ...How do I validate field encryption?
Use field encryption to protect sensitive information, such as Social Security numbers and birth dates, in the Connect database. The Validate Encryption routine will test the value stored in the encrypted field to make sure it is encrypted and ...