Shell Programming and Scripting

I have 2 text files say file1.txt and file2.txt . Some of the sample records for file1.txt were shown below:

XXXXX12345XXXXXXX12 3456789YYYYY
XXXXXXXXXX12345XX123457485YYYYY
XX12345XXXXXXXXXX123454658YYYYY

for file2.txt, some of the sample records were shown below:

XXXXXX12345656577ZZZZZZZZZZZZZZZZ
TTTTTTT12345837835ZZZZZZZZZZZZZZZZZ
ZZZZZZZ6385 64658YYYYYYYYYYYYYYY
XXXXXXXXXXXXXXXX12 3456789YYYYY

I need to find the common records that were present in file2.txt with respect to file1.txt provided THE ACCOUNT NUMBERS IN THE FILE2 SHUD BE COMPARED WITH FILE1 at particular postion from 18-26 only. It shud not take other relevant positions into consideration.

Any help could be really appreciated.

---------- Post updated at 02:31 PM ---------- Previous update was at 02:17 PM ----------

Help Help

Are the account number located in the same positions 18-26 in both files?

No..they are located at different positions I suppose

See this works for you:

Code:

sed 's/.\{17\}\(.\{9\}\).*/\1/' File2 > File2.acct
egrep -f File2.acct File1

That doesnt work..

---------- Post updated at 03:46 PM ---------- Previous update was at 03:39 PM ----------


sed 's/.\{17\}\(.\{9\}\).*/\1/' File2 > File2.acctThis has yielded all the account numbers from file1..what to do next ?

handles that pesky embedded space...

Code:

for i in $(cut -c 18-26 </tmp/file1.txt |tr ' ' '^' ) ;do echo $i ;grep -n "$(echo $i |tr '^' ' ')" /tmp/file2.txt ;done