This tab allows you to define in what way blocks of text will be parsed by fields and/or by variables:
Let us review an example with parsing currency rates. After parsing by blocks, we will have the following text as input:
We need to place "11.11.2009" to the [Date] field, "USD" - to the [Currency] field, and "1.51" - to the [Rate] field. To add a rule of parsing to the field, click the "Add..." button; to change the existing rule - click the Edit..." button. The window with rule settings will be opened.
Here you should specify:
Independent/Sequential Field Parsing
You can parse text by fields sequentially, as well as independently from other fields. The check box at the lower part of the "Fields/Variables" tab is responsible for this:
In case of independent parsing, the search for value of every field is started from the beginning of the text. In case of sequential parsing (the check box is not selected), the search for value of every field is started from the previous field. Sequential parsing is convenient if we have the same characters as delimiters, for example: 11.11.2009,USD,1.51 In this case, for correct parsing we have to specify:
The value of the [Currency] and [Rate] fields will be taken not from the beginning of the text, but from the previous value. This will also be reflected in the list of fields:
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.