Text (Fixed Length) Source

image\MainFormTextFixedLengthSource.gif

 

Text File Path

Path to the text file containing the data that will be the source for the extract.

File Open Dialog Button

Click this button to select the source text file using a Windows File Open dialog window.

Column Names on First Line of File

Set this option to true (checked) if column names are specified on the first line of the text file data source.

Line Terminator Appended to Each Line

Set this option to true (checked) if each line in the text input is terminated with a CR/LF (new line) character sequence.

If this option is false (unchecked) then there are no line terminators in the input file. See Expected Line Width setting below for how to define how long each line is.

Line Terminator Chars

CR/LF

Only carriage return/line feed characters recognized as line terminator for input text file.

Expected Line Width

You can have this field automatically calculated by using the Define Columns button.

Define Columns Button

Click this button to show the Fixed Length Text Input Definition Form.

Preview Source Button

Click this button to open the data source and show the data on an output grid.

Use this feature to get a preliminary view of what the input data looks like.

See Data Output Grid Overview for more information of working with the output grid.