I have a requirement to output bytes from a position which is dependent on another field in the file. The file is a VB file with data depending on a fixed section of 1000 bytes followed by variable blocks of 10 bytes each. The requirement is to get the data from the last variable block- the trailer count (position 50-55) is part of the fixed section.
For e.g. if the value of block count in position 50-55 is 1, i need to outrec 10 bytes from 1000 + 1* 10 ie 1010 position. If the value is 15, the field output should be from 1000 + 15 * 10 ie 1150th position.
One option was to have different IFTHEN OUTREC statements and hardcoding all values - but the number of combinations is huge.
Please let me know if there are options to select data from a position based on another field through sort.