Configuring Extract Editor Options
You can configure the following on the Configuration tab:
• File Properties: You can change the report file by clicking Browse and specifying another file. You can use this option to run the script you have designed against a different report file. Extract Editor loads the new file and applies the script.
Note: After changing the report file, previously defined line styles and fields are cached. If you do not want them, click 
Clear All Line Styles icon from the toolbar to reset the extract.
Clear All Line Styles icon from the toolbar to reset the extract.• Display Choices: The options displayed in this section are the same options displayed while creating the extract file. After creating the extract file, you can modify the sample size and padding options in this section. The options are:
• Starting Line
• Ending Line
• Sample Size
• Pad Lines
• Pad Line Length
For information about the descriptions, see Creating Extract Editor File.
• Extract Design Choices: You can specify the following options.
Property | Description |
|---|---|
Tag Separator | Distinguishes a field tag from the data field when analyzing a line of text. This is only relevant when you are using the Parse Tagged Data option. The available options are: • ColonSpace (: ): Distinguishes a field tag from the data field by a Colon and a Space. For example, Name: John M. Smith • Colon (:): Distinguishes a field tag from the data field by a colon only. For example, Name:John M. Smith. This is the default value. • SpaceColon ( :): Distinguishes a field tag from the data field by a space and a colon. For example, Name :John M. Smith • Dash (-): Distinguishes a field tag from the data field by a dash. For example, Name-John M. Smith • Comma (,): Distinguishes a field tag from the data field by a comma. For example, Name,John M. Smith • Vertical Bar (|): Distinguishes a field tag from the data field by a vertical bar. For example, Name|John M. Smith You can also specify your own tag separator. |
Column Separator | Distinguishes one column of data from the next when analyzing a line or block of text. This setting is only relevant when you are using the Parse Columnar Data option. Each column within a line of text becomes a data field. The available options are: • (2+) Spaces: Distinguishes between two columns of data by two or more spaces. This is the default value. For example, 10019 John M. Smith. The account number 10019 is one column or data field and the person's full name, John M. Smith, which contains single spaces, is another column or data field. • (1) Space: Distinguishes between two columns of data by one space. For example, 10019 John M. Smith. • Tab: Distinguishes between two columns of data by a tab space. For example, 10019 John M. Smith. • Vertical Bar(|): Distinguishes between two columns of data by a vertical bar. For example, 10019|John M. Smith. |
Flush Field Contents on Accept Default | Extract Editor outputs each record type as a fixed length consistent structure record. This means that even if a field or line does not exist in a particular section of a report, that field will exist in the output record. If this option is selected, then the field's contents are flushed after the record is sent to the output, that is, subsequent records will have the value of the flushed field as empty unless the field is collected again in the section being processed. |
Skip First Accept Default | When your report does not contain a consistent last line, you may have to define the Accept Record as the first line of a header or some other consistent line of text that appears at the beginning of each section of the report. This line will have the Accept Record line action. When this line action is chosen, the resulting first record will contain no data. It will be blank. To avoid a blank first record in your output file, select the Skip First Accept Default option. The Line Style window will use this value as the default for the Skip First Accept option while creating any new line styles. |
Trim Leading and Trailing Spaces | If this option is selected, then the Extract Editor removes all the leading and trailing spaces from the fields. This is useful for parsed columnar fields where you have a set field length but are not aware of the size of each piece of data. The Field Definition window will use this value as the default while creating any new fields. |
Last modified date: 08/02/2023