Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Gawk using Boolean "NOT"

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Gawk using Boolean "NOT"
# 1  
Old 06-19-2014
Gawk using Boolean "NOT"
How can I tell gawk to print out everything else my search finds? So once it finds all the lines in the file that contain "-1", I want it to print all the rest of the lines. Like:
Code:
cat test-file | grep -v '\-1'

I want this done using gawk
Code:
cat test-file | gawk -F '|' '{OFS="|";IGNORECASE=1;} ($4) ~/\-1/ {print $0}'

??
# 2  
Old 06-19-2014
try
Code:
nawk '$0 !~ /-1/' filename

is this working for gawk?
Last edited by Makarand Dodmis; 06-19-2014 at 12:53 PM..
# 3  
Old 06-19-2014
awesome. I see that I can also do this with gawk:
Code:
cat test-file | gawk -F '|' '{OFS="|";IGNORECASE=1;} ($4) ~/\-1/ {print $0}'

# 4  
Old 06-19-2014
Can we have sample input and expected output please
# 5  
Old 06-20-2014
Quote:
Originally Posted by metallica1973
awesome. I see that I can also do this with gawk:
Code:
cat test-file | gawk -F '|' '{OFS="|";IGNORECASE=1;} ($4) ~/\-1/ {print $0}'

Don't use cat, make awk read the file itself; and use the inversion !:
Code:
gawk -F '|' '{OFS="|";IGNORECASE=1;} ($4) !~ /\-1/ {print $0}' test-file

# 6  
Old 06-20-2014
Don't specify the variables for every line in the mid section. Try:
Code:
gawk -F '|' -v OFS='|' -v IGNORECASE=1 '$4 !~ /-1/'

But since neither IGNORECASE nor OFS are being used here and you probably do not want to discard lines where "-1" is part of bigger number of string, I suspect you are looking for this:
Code:
gawk -F\| '$4 != -1'

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies

2. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

3. UNIX for Beginners Questions & Answers

Gawk: PROCINFO["sorted_in"] does not sort my numerical array values

Hi, PROCINFO seems to be a great function but I don't manage to make it works. input: B,A,C B B,B As an example, just want to count the occurence of each letter across the input and sort them by decreased order. Wanted output: B 4 A 1 C 1 When I use this command, the PROCINFO... (4 Replies)
Discussion started by: beca123456
4 Replies

4. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

5. Solaris

The slices "usr", "opt", "tmp" disappeared!!! Help please.

The system don't boot. on the screen appears following: press enter to maintenance (or type CTRL-D to continue)...I checked with format command. ... the slices "0-root","1-swap","2-backup" exist. ...the slises "3-var","6-usr" -unassigned. :( (16 Replies)
Discussion started by: wolfgang
16 Replies

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

7. Shell Programming and Scripting

substituting the character ")" in gawk

Hi, I am using gawk to substitute the character ")" with ")\n" using sub function but it gives me the following error: gawk: cmd. line:3: (FILENAME= FNR=11) fatal: Unmatched \):/),/ The command is: gawk ' /^*function.*\(/,/\)/{sub(")",")\n")} ' (1 Reply)
Discussion started by: ghoda2_10
1 Replies

8. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

9. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies
Login or Register to Ask a Question