Sponsored Content
Top Forums Shell Programming and Scripting How to exclude certain colomn from the file? Post 302385144 by aoussenko on Thursday 7th of January 2010 07:01:28 AM
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...
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
regulatory.bin(5)                                                      Linux                                                     regulatory.bin(5)

NAME
regulatory.bin, regulatory.db - The Linux wireless regulatory database Description regulatory.bin and regulatory.db are the files used by the Linux wireless subsystem to keep its regulatory database information. regulatory.bin is read by crda upon the Linux kernel's request for regulatory information for a specific ISO / IEC 3166 alpha2 country code. regulatory.db is a newer, extensible database format which (since Linux 4.15) is read by the kernel directly as a firmware file. The regulatory database is kept in a small binary format for size and code efficiency. The regulatory.bin file can be parsed and read in human format by using the regdbdump command. The regulatory database files should be updated upon regulatory changes or corrections. Upkeeping The regulatory database is maintained by the community as such you are encouraged to send any corrections or updates to the linux-wireless and wireless-regdb mailing lists: linux-wireless@vger.kernel.org and wireless-regdb@lists.infradead.org SEE ALSO
regdbdump(8) crda(8) iw(8) http://wireless.kernel.org/en/developers/Regulatory/ regulatory.bin 21 December 2017 regulatory.bin(5)
All times are GMT -4. The time now is 07:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy