awk three conditions


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk three conditions
# 1  
Old 10-24-2012
awk three conditions

I'm having a problem pulling UID's from data. The data outputs a user's UID in one of three ways:
Code:
1. Error User user_name already assigned with <UID>
2. Success <UID> reserved for user_name
3. <a load of crap because there was a db failure yet somehow the UID is still in there>

I typically used an awk statement to pull out the UID until item 3 started happening which I cannot control. If the first word of the output said "Success" then the UID was always in value 12. If the first word was "Error" then the UID was value 7, but I wouldn't bother checking for "Error" I would just look for "Success" and print value 12, else print value 7 (the additional sed is just for formatting):
Code:
awk '{if ($1 == "Success") {print $12} else print $7","$NF}' txt_file | cut -d, -f2,3 | sed 's/,//g'

So fundamentally all I'm trying to do is add 1 more condition to the awk statement. I tried inserting elif and else if and I keep getting syntax errors. How can I insert that third condition?

GNU Linux using ksh.
# 2  
Old 10-24-2012
Use "elif". It works like this (see "man awk" for details):

Code:
if( <condition> ) {
     <code>
} elif( <other condition> ) {
     <code>
} ...
else {
     <code>
}

You can have as many "elif"s as you like. This way the if-branching does the same as the case-branching.

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
# 3  
Old 10-24-2012
Thanks - as previously stated I'm familiar w/ elif but I'm still receiving syntax errors. I believe I have followed as you have stated by placing the condition in single parenthesis and the code in single braces. Why am I receiving these errors?
Code:
awk: cmd. line:1: {if ($2 == "Success") {print $12} elif ($2 == "cannot") {print $52} else {print $7","$NF}}
awk: cmd. line:1:                                                         ^ syntax error
awk: cmd. line:1: {if ($2 == "Success") {print $12} elif ($2 == "cannot") {print $52} else {print $7","$NF}}
awk: cmd. line:1:                                                                     ^ syntax error

# 4  
Old 10-24-2012
use
Code:
else if

This User Gave Thanks to pamu For This Post:
# 5  
Old 10-24-2012
Quote:
Originally Posted by pamu
use
Code:
else if

It works.Yeah of course - it had to be something ridiculous like that. Just like when I had an sftp script starting with:
Code:
 /usr/bin/sftp $SERVER << EOL

And godforbid I didn't put the corresponding EOL in the right location otherwise it was treated as a comment. I'm sure there's a reason for these things but wow...
# 6  
Old 10-24-2012
Quote:
Originally Posted by MaindotC
And godforbid I didn't put the corresponding EOL in the right location otherwise it was treated as a comment. I'm sure there's a reason for these things but wow...
It's supposed to treat the text inside it completely literally, to the point people have used it to archive files; it has to be very picky about where it ends.

You can make it less picky with <<-EOF ... EOF instead of <<EOF ... EOF, which will cause it to strip tabs off the front of everything inside. Only tabs, not spaces.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sequence of conditions awk

hello gurus, I want to use an associative array from a file to populate a field of another file, by matching several columns in order of priority. If the first column matches, then i dont want to match $2. Similarly I only want to match $3 when $1 and $2 are not in associative array. For the... (6 Replies)
Discussion started by: ritakadm
6 Replies

2. Shell Programming and Scripting

awk problems - awk ignores conditions

awk 'BEGIN{ if('"$CATE"'<'"${WARN}"') printf ("%s", "'"`Kfunc "" ; break`"'") else if (('"${CATE}"'>='"${WARN}"') && ('"${CATE}"'<'"${CRIT}"')) printf ("%s", "'"`Wfunc ""; break`"'") else if ('"${CATE}"'>='"${CRIT}"') printf... (6 Replies)
Discussion started by: SkySmart
6 Replies

3. Shell Programming and Scripting

If conditions in awk

Hello Friends, I need to find some CDRs in production servers whose 1st field value and 2nd field value = 1 and 11th looks like 45.123... where there are more than 3 digits after comma.so i wrote a one liner, something like below but does not work, however when i used first and second conditions... (8 Replies)
Discussion started by: EAGL€
8 Replies

4. Shell Programming and Scripting

awk with conditions

Hi All, I have a file with below contents. "en2"/10.185.81.0:cluster_interconnect,"en5"/10.185.81.0:cluster_interconnect,"en6"/169.181.146.0:public I want to take the interface name from the file and convert it as ipaddress using ifconfig command get the output like below en6 ->... (2 Replies)
Discussion started by: kamauv234
2 Replies

5. Shell Programming and Scripting

Conditions in awk

Hi there, here is my command ssh host.local "/path/to/my/perscript/hostconfig.pl -s $HOST -d |awk '{if (\$4 > 120)print \"My error message\";exit}{s=0; for (i=1; i<=NF; i++) s++; if(s == 13) print \$3}'" The problem is if conditional 1 is met (i.e $4 > 120), i don't see "My error message", the... (5 Replies)
Discussion started by: urello
5 Replies

6. Shell Programming and Scripting

Checking conditions with AWK

Input File1 0BB2 2A11 Split,FriApr80625,1507_7RAID5 0BF6 2829 Synchronized,FriJan140653,1507_7RAID5 0BF6 282A Split,FriApr80625,1507_7RAID5 0C7C 199E Synchronized,FriJan140653,1507_7RAID5 0C7C 1BCC Split,FriApr80625,1507_7RAID5 0DCA 0A9B ... (12 Replies)
Discussion started by: greycells
12 Replies

7. Shell Programming and Scripting

awk line with two conditions

Hi there, I wanna define a variable 'tempbase'. Therefore I read a text file "base.out". "base.out" contains a list with four columns. 'tempbase' is the 4th entry in the line, where the first entry is equal to the predefined variable $orb1 and the second entry is equal to $orb2. I wrote the code... (2 Replies)
Discussion started by: friend
2 Replies

8. Shell Programming and Scripting

awk with two conditions

Hi Everyone, # cat 1 1;2;3;4;5;6 1;2;3;4;5; # awk -F ";" '$5 == "5"' 1 1;2;3;4;5;6 1;2;3;4;5; but the output is should be just "1;2;3;4;5;6" means 1st condition: $5 is 5; 2nd condition: $6 is not empty, please advice. Thanks (2 Replies)
Discussion started by: jimmy_y
2 Replies

9. Shell Programming and Scripting

if, sed or awk with conditions

I do not know how to do this unless I use a bunch of if statements. I need a script to replace numbers in each record in a file. I am really getting tangled in this web. If a fieldA (19 positions) is greater than 14 digits, I have to change the data (resulting fieldA is fixed 19 postions). If... (5 Replies)
Discussion started by: ski
5 Replies

10. Shell Programming and Scripting

About awk conditions

Hello, Can you explain why in the first 2 commands the awk does not print anything? Is it looking of a specific format ? Thanks. $ echo 12a3 | awk '($1>=2) {print $1}' # prints nothing $ echo 123a | awk '($1>=2) {print $1}' # prints nothing $ echo a123 | awk '($1>=2) {print $1}' a123... (1 Reply)
Discussion started by: majormark
1 Replies
Login or Register to Ask a Question