Is the file tab
delimited? This seems to work:
perl -alnF'\t' -e
'print if ($F[6] == 1)' inputfile.txt
HTH,
j
From: Dhundy Kiran
Bastola [mailto:dkbastola@mail.unomaha.edu]
Sent: Tuesday, January 12, 2010
5:43 AM
To: Jay Hannah
Subject: Re: 874
The file has too many rows for xls to open :)
How
do I do the following?
I have 7 column in a row
A file has say millions of rows
I would like to do a grep, based on the content of
6th or 7th column.
e.g. say the 7th column has either a 0 or 1
I would like to grep those rows that has a value
of 1
====================================
Dhundy (Kiran) Bastola, Ph.D.
Assistant Professor, Bioinformatics
Department of Computer Science
College of Information Science and Technology
Peter Kiewit Institute # 177D
University of Nebraska, Omaha, NE 68182
Phone: (402) 554-4899
Fax : (402) 554-3284
email : dkbastola@mail.unomaha.edu