SiMX: Input

Input

To load an input file, click the load Input button (). After an input file is loaded, TextConverter applies record and field delimiters preparing a tabular representation or input table view of the original text which is shown in the left part of the Input pane.

To view/browse the input file in its original form, click the icon icon associated with your input file. The icon appears to the right of the load Input button (). to view the original text file. Unlike the tabular columns in the output preview, the columns in the input view are not re-sizable. Note: If an input column contains a great deal of data, it may be necessary to scroll the input view window to the right to see the next column.

To search the data displayed in the input view press CTRL-F and a search dialog will appear.

A list of automatically generated input fields (the right part of the pane above) is called the Input Dictionary and will be used as a resource for further data manipulation.

Input field names can be retrieved from the input text. To do that, make sure that the option Get field names from the line # is set to 1.

TextConverter can work with all the data types encountered in a text document.

String "Silver"; "John Smith"

Date 10/11/2005; 10-Nov-2005; Thursday, November 10, 2005

Numeric $10,220.00; 123; 1.25e-3

Blob Hexadecimal encoding of binary data "00ff22aa1133bb88cc..."

Template/Parsing View

The left part of the input section contains Template View and Parsing View tabs. Template View displays an interactive version of the original input document after field delimiters, record delimiters, and records to skip have been applied. In Parsing View, the information is presented in a set of columns and rows. This approach greatly increases the transparency while facilitating control over the text conversion procedure.

All TextConverter panes are synchronized. When you select (click with a mouse on) a cell in the tabular text pane, an associated input field is selected in the input dictionary, an output field is selected in the output dictionary (see output) and, finally, a corresponding record is selected in the preview pane. This visual sequence allows you to see how each particular input value will look after the conversion.

The items selected with a yellow highlight correspond to the elements in the input and output dictionaries.

When you do not want to convert some particular input fields, you can remove their input-output connection (see connect input to output). The selected cell's background in the tabular text pane has a different color in this case, only tabular view <-> input dictionary and output dictionary <-> preview are synchronized (no input-output synchronization).

The tabular view below delivers additional convenience while working with positional input. The character position is shown under the mouse cursor when you keep it still for more than a half a second.

Input dictionary

The Input fields are elements of the input record and are displayed in the input dictionary. The input dictionary gives an ability to adjust the conversion settings and control access to the input fields from scripts.

You can modify the conversion procedure for a particular input text element (input field) by changing its format, connecting it to or disconnection it from an output field and through scripting.

- signifies a connected input field

- signifies an input field with no connections

Data types are recognized automatically by TextConverter and are used to initialize the automatically generated input and output field types. Sometimes there is not enough information for automatic data type recognition. For example, a date can be encoded into a text field as [01/Feb/1999:04:58:26]. For such cases, the format of the corresponding input field (Format column of the input dictionary) can be modified to use a custom mask: [DD/MMM/YYYY:H:m:s]. As a result, the date will be read in as 01/02/1999 04:58:26 AM. See output to learn how to change data types for output and input fields. Refer to date and numeric formats to learn how to manipulate text formats.

The input dictionary (and output dictionary) can be used for parsing with script. The following functions are available:

DictIn.GetFieldCount( )

DictIn.GetFieldValue( index|name )

DictOut.GetFieldCount( )

DictOut.GetFieldValue( index|name )

DictOut.SetFieldValue index|name, value

Related Sections

TextConverter's Concept Explained

Setting up a Conversion: Step-by-Step

Samples and walkthroughs

User Interface

Scripting