How do I find the particular field in a File?

velmani has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How do I find the particular field in a File? by particle (Vicar) on Apr 15, 2002 at 12:29 UTC
your perl script will need to know the structure of your data. how many fields? what are their names? what is the field seperator? what is the record seperator? once these things are defined, you can read in your data, and process it correctly. see split for details of splitting fields. also, see perldata for explainations of scalars and arrays.	[reply]
Re: Answer: How do I find the particular field in a File? by Anonymous Monk on Apr 28, 2007 at 01:27 UTC
Is the information in the file stored in a pattern as in tab spaces etc? Also are you looking for a particular value or a value in a particular row. If it is a value you can use the matching like `~ m/word pattern/` [download] If you know the row then you can sort through the array `$array[row]` [download] Shashidhar Iddamsetty	[reply] [d/l] [select]
Re: How do I find the particular field in a File? by ehdonhon (Curate) on Apr 15, 2002 at 13:30 UTC
If you are experienced in using DBI, you could take a look at DBD::AnyData. As long as your data is being stored in an AnyData compatable format, you should be able to use a simple SQL command to retrieve your info: `my $dbh = DBI->connect('dbi:AnyData(RaiseError=>1):'); $dbh->func( 'STUDENTS', 'CSV', 'students.csv' ); my $sth = $dbh->prepare("SELECT degree FROM STUDENTS WHERE STUDENT = + 'george'");` [download]	[reply] [d/l]
Re: How do I find the particular field in a File? by Juerd (Abbot) on Apr 15, 2002 at 10:02 UTC
By reversing the method you used to store it.	[reply]