View previous topic :: View next topic
|
Author |
Message |
Aneesh
New User
Joined: 30 Sep 2006 Posts: 60
|
|
|
|
Hi,
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.
Thanks,
Aneesh. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You mean you have 1000 fixed, then a number of 10-byte occurrences, then there is, after the final occurence on that record, the data you want?
What is in the 10 bytes? What is in the extra part? |
|
Back to top |
|
|
|