Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to exclude certain colomn from the file?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to exclude certain colomn from the file?
# 1  
Old 01-07-2010
How to exclude certain colomn from the file?
Hi
I have a file in the following format:
Code:
4135    f4135acc:    39798  rmtdb:     0  /t1/data/f4135acc.dta   
4135    f4135pdb:    39795  rmtdb:     0  /bb/data/f4135pdb.dta    
4135    p4135eng:        0    rmtdb:     0  /bb/bin/p4135eng           
4135    r4135eng:    14142  rmtdb:     0  /bb/bin/r4135eng           
4137    f4137acc:    39862  rmtdb:     0  /t1/data/f4137acc.dta     
4137    f4137pdb:    39859  rmtdb:     0  /t1/data/f4137pdb.dta

I need to exclude all the lines from the file in which colomn #3 has entry 0

Is it possible to do it with awk ? Thanks a lot for advice -A
Last edited by Scott; 01-07-2010 at 08:08 AM.. Reason: Code tags, please...
# 2  
Old 01-07-2010
Use this:-

Code:
nawk '($3 != 0)' infile.txt

SmilieSmilieSmilie
# 3  
Old 01-07-2010
Lets say, you input file name is a.txt, then

Code:
awk '$3!=0 {print }' a.txt

# 4  
Old 01-07-2010
Or even:
Code:
awk '$3' infile

# 5  
Old 01-07-2010
Thanks a lot guys !
# 6  
Old 01-07-2010
Just for completeness (under par Smilie ), we could use this too of course:
Code:
awk \$3 infile

# 7  
Old 01-07-2010
a very nice one Scrutinizer SmilieSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Remove duplicate in colomn

i have a file which have two columns, 2nd column have duplicate values and i want to delete and keep only distinct on basis on 2nd column. -bash-4.1$ cat file_re 7440 713543695 7441 713543695 4603 714457614 4602 714457614 40301 717937765 40281 717937765 33741 721208982... (2 Replies)
Discussion started by: mirwasim
2 Replies

2. Shell Programming and Scripting

Find and exclude what is in file

Hello everyone, I try to find folders older than 3 years and display them, but excluding some directories, the below code does NOT exclude listed directories: find . -maxdepth 3 -mtime +1095 -type d -exec ls -l {} \; | grep -vFf oldExclude >> older oldExclude Folder1/ Folder2/... (7 Replies)
Discussion started by: Abu Rayane
7 Replies

3. Shell Programming and Scripting

Exclude variable from a file

Hello, I have a list of patterns which I'd like to exclude from a file. I tried to do while read line do grep -v $line file >> new.file done < mylist But obviously it won't work. It only works for just grep. I know I can do: grep -Ev 'pattern1|pattern2|...' myfile but my... (7 Replies)
Discussion started by: coppuca
7 Replies

4. UNIX for Dummies Questions & Answers

Exclude file with tar

hi, i am trying to use a exclude file to exclude some file directories while making a tar archive. This is my command: tar -pcvf orahome10gR2.tar.gz db_1 -X /home/oracle/excludeFile.txt /home/oracle/ when i execute it, it seem to be tar-ing. But once is done, i cd to /home/oracle and could... (2 Replies)
Discussion started by: redologger
2 Replies

5. Shell Programming and Scripting

Exclude a file or not in

Hi Gurus. I have a directory and i receive many files with extension .log. I processed the file as i get it. i want to process all the files except one which i know i don't want to process. cd /backup/temp/rajesh/PACS #--- directory , under this i have below files... (1 Reply)
Discussion started by: guddu_12
1 Replies

6. Ubuntu

[Solved] Using Find with an exclude/exclude file

I am familiar with using tar and exclude/include files: tar zcf backup.dirs.tgz --files-from=include.mydirs --exclude-from=exclude.mydirs --no-recursion but was wondering if I could use find in the same way. I know that you can just specify the directories to exclude but my list is... (2 Replies)
Discussion started by: metallica1973
2 Replies

7. Shell Programming and Scripting

Have to exclude the first and last line of the file : help me

hi , i am very new to perl . scriptting.. pllease can any one help me ...pleaseeeeeee i ll have a file which look likes 123 |something |567 456 |welcome |789 457 |inboxpost |790 . . 123 |something |567 i have to execute all the lines in the file except the first and the... (14 Replies)
Discussion started by: vishwakar
14 Replies

8. Shell Programming and Scripting

ls to exclude file

I have cgicsave.env and cgic*, but I want to print cgic* value but NOT cgicsave.env Thanks (9 Replies)
Discussion started by: xs2punit
9 Replies

9. Shell Programming and Scripting

switch line to colomn

Hi It's possible to switch the line to colon from a file using Perl or AWK? for example my file have somthing like this: 10 11 12 13 14 20 21 22 23 24 30 31 32 33 34 I want to have a file with the line switched like : 10 20 30 11 21 31 12 22 32 13 23 33 14 24 34 Thanks a lot (4 Replies)
Discussion started by: rauchy
4 Replies

10. Shell Programming and Scripting

changing colomn to the line

I have a file which has only one colomn of numbers,ex: 122 173 292 400 979 2152 2339 2376 2387 2446 2450 What ksh / unix command should I use to create a file in which those numbers will be in one line,like this 122 173 292 400 979 .... etc Thanks a lot for help (9 Replies)
Discussion started by: aoussenko
9 Replies
Login or Register to Ask a Question