Joined: 14 Mar 2008 Posts: 74 Location: India,Chennai
I am trying to extract records from a VB file which has different record type. I need to extract the reference number, if the product code is 'xxxx'. The product code is in different position for each record type.
The file has three record types.
If record type is 'A', the reference number starts from 26 and is 5 byte long. The product code starts from 31 and is 4 bytes.
If record type is 'B', the reference number starts from 40 and is 5 byte long. The product code starts from 45 and is 4 bytes.
I need not reffer other record types.
the record type is in position 25 and is 1 byte.
The output should be a FB file and record length should be 9 bytes.
I tried the following sort card, but the include condition does not work properly. If i remove the include condition, i get the formated records for all the records in file. If i have the include condition i get empty file.