11-30-2010
Awk 'if' statement help
Hello all,
I'm very new to this (<5hrs!) please bear with me. My file looks like this
386259.448541 417069.155 154935.157 186.206 162 1 1 8
386259.448551 417068.53 154935.04 186.144 156 1 1 8
386259.448561 417067.911 154934.926 186.175 164 1 1 8
386259.450337 417086.643 154946.483 894.671 0 7 1 13
386259.450704 417083.859 154945.922 893.228 0 7 1 14
386259.451101 417082.752 154945.736 897.596 0 7 1 14
I need to first count the number of, and then remove the whole line, where $4 is > a threshold value (say 300).
I have tried to execute a number of 'if' statements based on posts / tutorials I have found but get syntax errors.
Any help most gratefully received!
Rebecca
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Friends
How do I do two things from one if statement inside awk? I want to run a script and create a new file from the same condition.
awk '{ if ($2 == ""){print " "|"cd /local/test; ./script.ksh"}{cat > ran_true.txt}}' $IN_FILE
Bolded are the two things I want to be done.
Thanks (1 Reply)
Discussion started by: UNovIX
1 Replies
2. Shell Programming and Scripting
hi all,
i have two files
1) a.txt
one
two
three
2)
abc "one" = 10
pqr "three" = 20
345 "two" = 0
this is what i want in third file (3 Replies)
Discussion started by: shishirkotkar
3 Replies
3. Shell Programming and Scripting
Having a little trouble with awk and an if statement. I have a test setup which I am trying to only print the records which start with the month 03. Everything I tried, prints everything, even the 02 month
03/23/2010 12:47:51
ga2828
SUBMITTED FROM URL: test123.cgi
show port count
... (2 Replies)
Discussion started by: numele
2 Replies
4. Shell Programming and Scripting
Hi,
I have a data file which contains record count.
So doing wc -l rightfit_balancing_count.dat | awk '{print $1}'] gives me the record count stored in the file.
Now, i want to send a mail from UNIX, if the record count is equal to 0,otherwise it should do nothing.
Any help... (2 Replies)
Discussion started by: Shell_Learner
2 Replies
5. Shell Programming and Scripting
hi,
I have a l-column file of more than 10,000 lines with interspersed negative values. What I want to do is add a fixed number (360) everytime a negative value is encountered while leaving the positive ones as is. I need something that will read every line of the file and do the calculation... (3 Replies)
Discussion started by: ida1215
3 Replies
6. Shell Programming and Scripting
Hi
I have a file with
test test2 1000000657373
test1 test3 1000003849450
test2 test4 test5 100000837474
I cat the file and pipe it to an awk statement like so
cat /tmp/file |awk '{if ($3 ~ "^*$" && $3 > 1024000000) print "/vol/"$1"/"$2;else if ($4 ~ "^*$" && $4 > 1024000000) print... (15 Replies)
Discussion started by: bombcan
15 Replies
7. Shell Programming and Scripting
I run my script "switch.sh" repeatedly (within 30 seconds). Each time script is triggered, script itself should kill all previous process.
Here is my code:
for pid in $(ps -fe | grep 'switch.sh' | grep -v grep | awk '{if ($2<$$) print $2}'); do
sudo kill -9 $pid
done
sleep 30
... (6 Replies)
Discussion started by: armatron
6 Replies
8. Shell Programming and Scripting
I am using awk as part of and if then else statement. I am trying to have the user enter a gene name and then a variant or variants and have a specific transcript assigned to the variants depending on the gene. Below is my code but the if then else statement is wrong. Basically, the gene name... (2 Replies)
Discussion started by: cmccabe
2 Replies
9. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
10. Shell Programming and Scripting
There has to be a way to do this with awk or maybe I'm just focusing on the wrong tool and making this harder than it needs to be.
I'm trying to do a file field lookup/join at a very large scale but the output changes has to change dramatically. I have an input file to do a field lookup from and... (3 Replies)
Discussion started by: brettcasper
3 Replies
LEARN ABOUT HPUX
pthread_cleanup_pop
pthread_cleanup_pop(3T) pthread_cleanup_pop(3T)
NAME
pthread_cleanup_pop(), pthread_cleanup_push() - remove or register a cancellation cleanup handler
SYNOPSIS
PARAMETERS
routine Routine registered as a cancellation cleanup handler.
arg Parameter to be passed to the cancellation cleanup handler
execute Indicates if the popped cancellation cleanup handler is to be executed.
DESCRIPTION
installs the cancellation cleanup handler routine onto the calling thread's cancellation cleanup stack. This handler will be popped from
the calling thread's cancellation cleanup stack and called with the arg parameter when any of the following occur:
(a) the thread calls or returns from its start routine.
(b) the thread acts upon a cancellation request.
(c) the thread calls with a non-zero execute argument.
When a thread terminates, it will execute each of the cancellation cleanup handlers on its cancellation cleanup stack. These handlers will
be popped and executed in the reverse order that they were installed (
removes the cancellation cleanup handler at the top of the calling thread's cancellation stack. If execute is non-zero, the cancellation
cleanup handler is called after it is removed from the cancellation stack. If execute is zero, the cancellation cleanup handler is simply
removed and will not be called.
and must appear as statements and in pairs within the same lexical scope. These functions may be macros which contain the opening '{' in
the push function and the closing '}' in the pop function.
Calling or is undefined if there have been any calls to or made without the matching call since the jump buffer was filled.
Calling or from inside a cancellation cleanup handler results in undefined behavior unless the corresponding or was also done inside the
cancellation cleanup handler.
RETURN VALUE
The and functions must be used as statements. They do not have return values or errors.
ERRORS
None.
WARNINGS
The functions and must be called in the same lexical scope or the result is undefined behavior.
AUTHOR
and were derived from the IEEE POSIX P1003.1c standard.
SEE ALSO
pthread_cancel(3T), pthread_setcancelstate(3T).
STANDARDS CONFORMANCE
Pthread Library pthread_cleanup_pop(3T)