Property | S/T | Description |
---|---|---|
NumericFormatNormalization | S | When set to true, handles thousands-separators according to usage for locale when numeric strings are converted to numeric type. This property overrides any individual field settings. Default is false. |
InsertEOFRecSep | S | This option inserts a record separator on the last record of the file, if it is missing. The default is false. If set to true, this property captures the last record (with no record separator) instead of discarding it. • If the property options define a specific separator (such as CR-LF, LF), the specified separator must exist at the end of all records, including the last record in the file. Any trailing data without that separator is ignored. To avoid losing your last line of data if it does not contain the appropriate record separator, we suggest either manually editing (for one or two affected files) or creating a program (for several affected files) that adds a record separator at the end of the last record. • If a terminating record separator already exists, a blank line is read at the end of the file. Depending on your target or export type, you may need to use a script to filter out blank lines and avoid errors in exported data. |
Sample Size | S | Allows you to set the number of records (starting with record 1) that are analyzed to set a default width for each source field. The default value is 1000. You can change the value to any number between 1 and the total number of records in your source file. As the number gets larger, more time is required to analyze the file, but it may be necessary to analyze every record to insure no data is truncated. To change the value, click StyleSampleSize, highlight the default value, and type a new value. |
StartOffset | S | If your source data file starts with characters that need to be excluded from the transformation, set the StartOffset option to specify at which byte of the file to begin. The default value is zero. The correct value may be determined by using the Hex Browser. This property is set in number of bytes, not characters. |
StripLeadingBlanks | S | By default, leading blanks are left in fixed ASCII source data. To delete leading blanks, set StripLeadingBlanks to true. |
StripTrailingBlanks | S | By default trailing blanks are left in fixed ASCII source data. To delete trailing blanks, set StripTrailingBlanks to true. |
FieldSeparator | T | Allows you to choose a field separator character for your target file. The default is None. The other choices are comma (,), tab, space, carriage return-line feed (CR-LF), line feed (LF), carriage return (CR), line feed-carriage return (LF-CR), control-R, and pipe (|). If the record separator is not one of the choices from the list and is a printable character, highlight None and then type the correct character. For example, if the separator is an asterisk (*), type an asterisk from the keyboard. If the field separator is not a printable character, replace None with a backslash, an X, and the hexadecimal value for the separator. For example, if the separator is a check mark, then enter \XFB. For a list of the 256 standard and extended ASCII characters, search for "hex values" in the documentation. |
Fill Fields | T | Writes an ASCII data file where every field is variable length. If this property is set to false, all trailing spaces are removed from each field when the data is written. The default is true. The true setting pads all fields with spaces to the end of the field length to maintain the fixed length of the records. |
Ragged Right | T | Writes an ASCII data file where the last field in each record is variable length when set to true. The default is false. The false setting pads the last field with spaces to the end of the record length to maintain the fixed length of the records. You must set FillFields to false for the RaggedRight property to work properly. The Ragged Right property has no effect if you set FillFields to true. If you set FillFields to false, then the RaggedRight property determines whether blank fields and fields with only spaces as their data still appears at the end of the record. |
DatatypeSet | S/T | Allows you to choose between standard and COBOL data types in your fixed ASCII data file. Standard is the default and means that all the data in the file is readable (lower) ASCII data. If your fixed ASCII file contains (or needs, for target file) COBOL display type fields and you are using a COBOL 01 copybook (fd) to define the fields, you MUST change this property option to "COBOL" before connecting to the COBOL copybook in the External Structured Schema window. |
RecordSeparator | S/T | A fixed ASCII file is presumed to have a carriage return-line feed (CR-LF) between records. To use other characters as the record separator or no record separator, click RecordSeparator for a list of choices, including system default, carriage return-line feed (default), line feed, carriage return, line feed-carriage return, form feed, empty line, ctrl-E, and no record separator. To use a separator other than one from the list, enter it here. The SystemDefault setting enables the same transformation to run with CR-LF on Windows systems and LF on Linux systems without having to change this property. If the record separator is not one of the choices from the list and is a printable character, highlight the CR-LF and then type the correct character. For example, if the separator is a pipe (|), type a pipe from the keyboard. If the record separator is not a printable character, replace CR-LF with a backslash, an X, and the hexadecimal value for the separator. For example, if the separator is a check mark, then enter \XFB. For a list of the 256 standard and extended ASCII characters, search for "hex values" in the documentation. |
Tab Size | S/T | If your fixed ASCII source file has embedded tab characters representing white space, you can expand those tabs to set a number of spaces. The default value is zero. To change it, highlight the zero and then type a new value. |
CodePage | S/T | This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US. |