The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 12-02-2005
shashi_kiran_v shashi_kiran_v is offline
Registered User
  
 

Join Date: Jun 2005
Posts: 40
Select records based on search criteria on first column

Hi All,

I need to select only those records having a non zero record in the first column of a comma delimited file.

Suppose my input file is having data like:

"0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005"
"0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"
"552130000","01/08/2005 07:16:53",2,3,"FIDS_Accept",,"01/08/2005"

Then I need the output having only

"552130000","01/08/2005 07:16:53",2,3,"FIDS_Accept",,"01/08/2005"

Thanks
Shash