Defining Your Input File - Finalist - 10.0

Finalist Guide

Product type
Software
Portfolio
Verify
Product family
Data Quality - Postals
Product
Finalist
Version
10.0
Language
English
Product name
Finalist
Title
Finalist Guide
Copyright
2023
First publish date
1984
Last updated
2024-05-15
Published on
2024-05-15T00:57:22.811031

To define your input file options, follow these steps:

  1. To define your input file type, select one of the following:
    1. If your input file is in an ASCII fixed file format and each record in your input file occupies a fixed number of bytes (no CR/LF at the end of each record), click ASCII for Fixed Input. To define the record length of the records in your input file, enter a number in the range of 1-32,767 in the Record Size field.
    2. If your input file is in a mainframe fixed file format and each record in your input file occupies a fixed number of bytes (no CR/LF at the end of each record), click MF for Fixed Input. To define the record length of the records in your input file, enter a number in the range of 1-32,767 in the Record Size field.
    3. If your output file is in a mainframe file format or you want to define an output Record Size, enter a number in the range 1-32,767 in the Record Size Out field.
    4. If each record in your input file is terminated with a carriage return/line feed (CR/LF) pair, click ASCII CR/LF Input.
  2. If the records in your input file are delimited by a specific character called a delimiter (a character that marks the beginning or end of a unit of data), select one of the following:
    1. If the records in your input file are delimited by a tab, click Tab.
    2. If the records in your input file are delimited by a comma, click Comma.
    3. If the records in your input file are delimited by a specific character, click Character. Specify the delimiter character in the field to the right of Character.
    4. If the records in your input file are delimited by a hexadecimal value, click Hex value. Specify the delimiter character in the field to the right of Hex value. For example, if you enter 09 in the delimiter field, 09 is the ASCII hexadecimal value for the tab character.
  3. If your input file is a dBase file, click dBase Input File.