Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| select a record from one file matching from second file using awk | synmag | Shell Programming and Scripting | 7 | 06-12-2008 02:37 AM |
| how to read record by record from a file in unix | raoscb | UNIX for Dummies Questions & Answers | 1 | 05-16-2008 06:30 AM |
| Script to search a bad record in a file then put the record in the bad file | shilendrajadon | UNIX for Advanced & Expert Users | 1 | 12-28-2007 10:00 AM |
| splitting a record and adding a record to a file | rsolap | Shell Programming and Scripting | 1 | 08-13-2007 01:58 PM |
| how to delete record in file data with index in another file? | zhynxn | Shell Programming and Scripting | 0 | 07-06-2006 12:03 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
12-28-2007
|
||||
|
||||
Script to search a bad record in a file then put the record in the bad file
I need to write a script that can find a bad record (for example: there is date field colom but value provided in the file for this field is N/A) then script shoud searches this pattern and then insert the whole record into the bad file.
Example: File1 Name designation dateOfJoining Shilendra SE 12/28/2007 Brijesh SE 12/25/2007 Sunil JSE N/A Pankaj SE 12/20/2007 Manish SE N/A Akhilendra SE 11/20/2007 Then after running the script the file should be like File1 Name designation dateOfJoining Shilendra SE 12/28/2007 Brijesh SE 12/25/2007 Pankaj SE 12/20/2007 Akhilendra SE 11/20/2007 And bad file will contain the record for which date was N/A BadFile Name designation dateOfJoining Sunil JSE N/A Manish SE N/A Pls help me out as soon as possible. Thanks. |
|
12-28-2007
|
||||
|
||||
|
You can use grep, check the manpage.
Regards |
|
12-28-2007
|
|||||
|
|||||
|
Code:
awk '{print > ( $3=="N/A" ) ? "bad_file" : "tmp" }' file1
mv tmp file1
|
| Sponsored Links | ||
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
