Import_Checks_Delimiter

Import Checks - Delimiter

Enter the delimiter used in the user-defined delimited file (CSV) to separate data. 

A delimiter is a specific character or symbol used to separate pieces of data within a file or string. Delimiters help software systems identify where one field ends and the next begins during data parsing or processing. 

Example
CheckNumber,Payee,Amount,Date
12345,John Smith, 150.00,2024-05-28

In this example, the comma (,) is the delimiter. It separates each field: 

  • CheckNumber

  • Payee

  • Amount

  • Date

 

Common types of delimiters

Delimiter

Description

Example

,

Comma

John,Smith,100.00,2024-05-28

\t

Tab (used in TSV files)

John Smith 100.00 2024-05-28

|

Pipe

John,Smith|100.00|2024-05-28

;

Semicolon

John,Smith;100.00;2024-05-28

:

Colon

John,Smith:100.00:2024-05-28

 

 

Why delimiters matter

  • They structure flat files (like .csv or .txt) so that software can read and map files correctly. 

  • Delimiters make it easy to import/export data between systems. 

  • The choice of delimiter depends on the software's requirements and the nature of the data (for example, avoid commas if fields might include commas).

 

Considerations

  • If your data contains the delimiter itself (for example, a name like "smith, Jr."), you'll need to quote or escape the data: "Smith, Jr." instead of "Smith, Jr. in a CSV.

  • Connect applications, supports custom delimiters (you can choose the character). 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • Import Checks - Import file type

      An import file is used to transfer checks from one system to another. It can be formatted using a comma-separated value or fixed-length field value, also referred to as the import file type. You will need to select the import file type to determine ...

    • How do I import checks? (2024.11)

      Importing checks can streamline payment processing, record-keeping, and reconciliation. Bulk processing and automation. Importing checks allows an organization to process multiple payments at once, saving time compared to manual entry. It reduces ...

    • Import Checks - Import file name

      Enter the import file name, include the path (d:\myfiles\filename.csv). The import file name is the name of the file that is being used to import data into Connect applications. While the name itself doesn't affect the data inside the file, it often ...

    • Import Checks - Source application

      In importing checks, a source application is the Connect application where you want to see the imported checks. What is a source application? It's the system that holds the check data. After the checks are imported into Connect Check on Demand, the ...

    • Import Checks - GL account

      Enter a GL account to assign to imported checks that do not have a GL account included in the import file. The GL account tells the system where the expense or payment should be recorded in the general ledger. Why the GL account is important? ...