rajeevdas03 Warnings : 1 New User
Joined: 21 Jan 2006 Posts: 19 Location: Mumbai
|
|
|
|
Hi,
I have File1 which conatis below fields;
FILE1: lenghth is 40 bytes
1 to 10 position A/C number
11 to 6 amount
17 t0 10 date
File 2 contains below fields:
FILE2: lenghth is 120 bytes
1 to 10 positions A/C number
16 to 5 position St Cd
21 to 3 position st type
40 to 10 position date
My requirement is to math file1 and file2 based on A/C number and if matches found my out put record should have
A/C number,amount and date and st cd,st type and date
Please help me how to get this. |
|
bodatrinadh
Active User
Joined: 05 Jan 2007 Posts: 101 Location: chennai (India)
|
|
|
|
Hi Rajeev,
By using joinkeys you can achieve it.
Code: |
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
REFORMAT FIELDS=(F1:1,40,F2:16,8,F2:40,10)
SORT FIELDS=COPY
|
Quote: |
I am a new joinee of this group,working in a softwrae company,time to time I need help.
|
The person who joined in 2006 will not consider as a "new joinee."
Thanks
-3nadh |
|