Shell Programming and Scripting

awk  -v PAT="two,three,four" '                  # define search pattern
BEGIN   {KC = split(PAT, T, ",")                # fill temp array with keywords from pattern, find key count
         RB = KC + 2                            # compute ring buffer size
        }
        {A[NR%RB] = $1                          # fill ring buffer for line number
         B[NR%RB] = $2                          # fill ring buffer for keywords
         if ($2 == T[CNT+1])    CNT++           # if keyword match found: advance to next keyword
         else                   CNT = 0         # else start again from first keyword

         if (CNT == KC) {printf "%s,", A[(NR+1)%RB]
                                                # BINGO! ALL keywords in a row! print line number

                         for (i=1; i<=2; i++) printf "%s,", B[(NR+i)%RB]
                                                # print two preceding words

                         print PAT              # print the search words 
                         CNT = 0                # and start again from first keyword
                        }
        }
' file
3,horse,one,two,three,four

awk  -v PRC=4 -v PAT="two,three,four" '         # define search pattern
BEGIN   {KC = split(PAT, T, ",")                # fill temp array with keywords from pattern, find key count
         RB = KC + PRC                          # compute ring buffer size
        }
        {A[NR%RB] = $1                          # fill ring buffer for line number
         B[NR%RB] = $2                          # fill ring buffer for keywords
         if ($2 == T[CNT+1])    CNT++           # if keyword match found: advance to next keyword
         else                   CNT = 0         # else start again from first keyword

         if (CNT == KC) {printf "%s,", A[(NR+1)%RB]
                                                # BINGO! ALL keywords in a row! print line number, -

                         for (i=1; i<=PRC; i++) printf "%s,", B[(NR+i)%RB]
                                                # print two preceding words

                         print PAT              # print the search words 
                         CNT = 0                # and start again from first keyword
                        }
        }
' file