Need to compare two files with one Column

venkatarao · New User Joined: 19 Dec 2004 Posts: 23 Location: hyderabad

Hi,

Let me know how to do this comparision.

I need to compare two files with one Column, which is present in different positions and copy all the matched records to new output file.

Thanks,

Aaru · Posted: Wed Dec 03, 2008 3:02 pm

Hi,

venkatarao · New User Joined: 19 Dec 2004 Posts: 23 Location: hyderabad

Hi Aaru,

Both are FB Files.
File1 record length 20 bytes we need to take firest 10 bytes of account number field.

File2 record length is 200 bytes we need compare 10 bytes of starting from 21 postion.

Frank Yaeger · Posted: Wed Dec 03, 2008 11:09 pm

venkatarao,

Show an example of the records in each input file (relevant fields only) and what you expect for output. Give the "rules" for getting from input to output. If input file1 can have duplicates within it, show that in the example. If input file2 can have duplicates within it, show that in the example. Give the starting position, length and format of all relevant fields.