Since you don't describe the data format, this is going to be a general soln. If you have space delimited text you could do the following. 
This is the datafile of space delimited.
1 fruit apple,pear
2 fruitloop orange,yellow
3 fruitcake yummy,bad
4 car bug,volvo,toyota,jag

#!/usr/bin/perl -w
use strict;
my $keywordcol = 2; # keywords are in this column
my $wordpattotest = '\wag';
my $wordtotest = 'orange';
my $datafilename = 'in.dat';
open(IN,$datafilename);
my @data;
while(<IN>) {
    my (@fields) = split(/\s+/,$_); 
    # if you wanted to have data separated by tabs, replace \s with \t
+, 
    # remove the '+' if you don't want multiple consecutive 
    # separators to be treated as one.

    if( $fields[$keywordcol] =~ /$wordpattotest/ ) {
    print;
    }
    # or if you wanted to find exact words you could loop
    # over the keywords
    foreach my $w ( split(/,/,$fields[$keywordcol] ) ) {
    print if( $w eq $wordtotest);
    }
    push @data, \@fields;
}

# If you wanted to sort the data by a specific column
my $coltosort = 1;
foreach my $row ( sort { $a->[$coltosort] cmp $b->[$coltosort] } @data
+ ) { 
# replace cmp with <=> if data is numeric
 print join(' ', @$row), "\n"
}

[download]

In reply to Re: How do i extract records from a file containing a certain keyword in 1 field? by stajich
in thread How do i extract records from a file containing a certain keyword in 1 field? by redemption

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.