Page 1 of 1

Using the POS parameter in extracting data from tables

Posted: Sat Oct 28, 2006 7:47 pm
by Hannes, Tech Support
In cases where you do not want to extract the whole table (as described in, it is often the case, that the data you want to extract can be found by following a certain sequence of position (POS) values.

Let's say, we find (by using the Extraction Wizard) that the first three relevant fields have the same EXTRACT tag, but they differ in the position (POS) value, which is 2 for the first, 5 for the second and 8 for the third.

Having a closer look at these numbers, we may find that they belong to the sequence: 2, 5, 8, 11, 14, ... i.e. each element is the result of adding three to the element before.

We can then easily extract all relevant data by looping through this sequence in a script.