Property | S/T | Description |
|---|---|---|
AlternateFieldSeparator | S | Most data files have only one field separator between all the fields; however, it is possible to have more than one field separator. If your source file has one field separator between some of the fields and a different separator between other fields, you can specify the second field separator here. Otherwise, you should leave the setting at None (the default). The alternate field separators available from the list are none (default), comma, tab, space, carriage return-line feed, line feed, carriage return, line feed-carriage return, Ctrl-R, and pipe ( | ). To select a separator from a list, click AlternateFieldSeparator. If you have an alternate field separator other than one from the list, you can type it here. If the alternate field 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 an asterisk ( * ), type an asterisk from the keyboard. If the field 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. |
AutomaticStyling | S | Automatic styling changes the way Common Logfile Format Webserver data is read or written. By default, AutomaticStyling is set to false, causing all data to be read or written as Text. When set to true, data types such as numeric and date fields, are formatted automatically. During the transformation process, autostyling insures that a date field in the source file is formatted as a date field in the target file, as opposed to character or text data. If your source file contains zip code data, you may want to leave AutomaticStyling as false, so leading zeros in some zip codes in the eastern United States do not get deleted. |
FieldEndDelimiter | S | All Common Logfile Format Webserver files are presumed to have beginning-of-field and end-of-field delimiters. The default delimiter is a quote ( " ) because it is the most common. However, some files do not contain field delimiters, so this option is available for both your source files and your target files. To read from or write to a file with no delimiters, set FieldEndDelimiter to None. |
FieldSeparator | S | The integration platform assumes that a Common Logfile Format Webserver file should have a space between each field. To specify some other field separator, click FieldSeparator to display the options: comma (default), tab, space, carriage return-line feed, line feed, carriage return, line feed-carriage return, ctrl-R, a pipe ( | ), and no field separator. To use a field separator that is not on the list, type it here. If the field separator you want to use is not on the list and is a printable character, highlight the CR-LF 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 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. |
FieldStartDelimiter | S | All Common Logfile Format Webserver files are presumed to have beginning-of-field and end-of-field delimiters. The default delimiter is a quote ( " ) because it is the most common. However, some files do not contain field delimiters, so this option is available for both your source files and your target files. To read from or write to a file with no delimiters, set FieldStartDelimiter to None. |
Header | S | In some files, the first record is a header record. For source data, you can remove it from the input data and cause the header titles to be used automatically as field names. For target data, you can cause the field names in your source data to automatically create a header record in your target file. To identify a header record, set Header to true. The default is false. |
RecordFieldCount | S | If your Common Logfile Format Webserver data file has field separators, but no record separator, or if it has the same separator for both the fields and the records, you should specify the RecordSeparator (most likely a blank line), leave the AlternateFieldSeparator option blank and enter the exact number of fields per record in this box. The default value is zero. |
RecordSeparator | S | A Common Logfile Format Webserver file is presumed to have a carriage return-line feed (CR-LF) between records. To use other characters for a record separator, click the RecordSeparator cell and click once. Then click the arrow to the right of the box and click the desired record separator in the list box. The choices are 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, you can type it here. 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. |
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. Note: This property is set in number of bytes, not characters. |
StripLeadingBlanks | S | Allows you to determine if leading blanks are stripped from all data fields. The default is false; leading blanks are not stripped from Common Logfile Format Webserver data. To remove them, set StripLeadingBlanks to true. |
StripTrailingBlanks | S | Allows you to determine whether or not trailing blanks are stripped from the data fields. The default is false; trailing blanks are not stripped from Common Logfile Format Webserver data. Set StripTrailingBlanks to true to remove trailing blanks. |
StyleSampleSize | S | Set the number of records (starting with record 1) that are analyzed to set a default width for each source field. The default value for this option is 5000. 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, and it may be necessary to analyze every record to ensure no data is truncated. To change the value, click StyleSampleSize, highlight the default value, and type a new one. |
CodePage | S | This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US. |