I was able to cut the large file to small based on the pattern. I used word wild card search to find patent numbers and made a txt file neming small

I found answers from superuser to cut the file for what I want

http://superuser.com/questions/99066...search-pattern
grep -f small_list.txt big_file.txt

Now I have made the resultant file in excel having only 3 column
1st column containing Patent numbers, second for event date and last for event code.
Is it possible with small files to do the above task

I also created word document having table with same as excel file if thats easy to be used.