In the Content tab, using the following options, you can specify the format of the source files.
| Option | Description |
|---|---|
| Filetype | Select either CSV or Fixed length. Depending on the file type you select, a corresponding interface appears when you click Get Fields in the Fields tab. |
| Separator | Specify the character used to separate the fields in a single line of text, typically a semicolon or tab. Click Insert Tab to place a tab in the Separator field. The default value is semicolon (;). |
| Enclosure | Specify an optional character used to enclose a field if that field contains a separator character. The default value is double quotation marks ("). |
| Allow breaks in enclosed fields | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Escape | Specify one or more characters to indicate if another character is a part of a regular text. For example, if a backslash (\) is the escape character and a single quote (') is an enclosure or separator character, then the text Not the nine o\’clock news is parsed as Not the nine o’clock news. |
| Header | Select if your text file has a header row (first lines in the file). Set Header to 1 (one). |
| Footer | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Wrapped lines | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Paged layout (printout) | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Compression | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| No empty rows | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Include filename in output | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Rownum in output | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Format | Select UNIX. |
| Encoding | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Length | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Limit | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Be lenient when parsing dates? | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| The date format Locale | This field is either not used by the Spark engine or not implemented for Spark on AEL. |
| Add filenames to result | This field is either not used by the Spark engine or not implemented for Spark on AEL. |