Shubhendu Chakraborty
New User
Joined: 20 Nov 2019 Posts: 3 Location: US
|
|
|
|
Hi,
I have 1 file of 10 bytes, first byte is Key and rest 9 have some value
Ex.
A111111111
B222222222
C333333333
My second file is of 20 bytes, first byte as Key and rest is random value
Ex.
AQWQW111111111ASWQQQ
B222222222QWQEFDFDFRER
CSDFGDFDG333333333FGGG
CFDSFDSFFDSFFSDDSFDSSF
BDFSFDSFFSDFEWREWREEW
My expected result to include records from file 2 which has matching value from file 1 position 2 to 9 bytes with sub string of file 2:
AQWQW111111111ASWQQQ
B222222222QWQEFDFDFRER
CSDFGDFDG333333333FGGG
I tried below but its not working:
JOINKEYS FILES=F1,FIELDS=(1,1,A)
JOINKEYS FILES=F2,FIELDS=(1,1,A)
REFORMAT FIELDS=(F1:1,10,F2:1,20)
SORT FIELDS=(1,10,CH,A)
INCLUDE COND=(12,19,SS,EQ,2,9,CH)
OUTREC=(1:11,20)
Please guide me with the same. |
|