Sequence of conditions awk Post: 302941398

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Sequence of conditions awk Post 302941398 by ritakadm on Wednesday 15th of April 2015 06:43:23 PM

04-15-2015

Registered User

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 following piece of code, all the steps are sequentially executed.

Code:

awk 'NR==FNR{array[$1]=$2;next}
                      $1 in array { $5=array[$1]}
                      $2 in array { $5=array[$2] }
                      $3 in array { $5=array[$3] }1' file1 file2

How do I code if condition here if I want to execute a row if only the upper one was not met?

like

Code:

awk 'NR==FNR{array[$1]=$2;next}
                      $1 in array { $5=array[$1]}

If not $1 in array

                      $2 in array { $5=array[$2] }

If not $1 and $2 in array

                      $3 in array { $5=array[$3] }1' file1 file2

I have 13 such conditions, so just wanted to learn how it is coded

Last edited by ritakadm; 04-15-2015 at 07:51 PM..

ritakadm

View Public Profile for ritakadm

Find all posts by ritakadm

10 More Discussions You Might Find Interesting

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

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

3. Shell Programming and Scripting

specifying multiple conditions in AWK

how can i specify more than 1 consition in the following AWK statament?? i.e. if $2 is ABCD and $3 is MNOP and $4 is KLPM similarly for OR #!/bin/ksh awk -F '' ' $2 == "ABCD" { print $2, $3;}' file.xml

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

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

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

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

8. Shell Programming and Scripting

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

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

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

LEARN ABOUT PHP

reset

RESET(3)								 1								  RESET(3)

reset - Set the internal pointer of an array to its first element

SYNOPSIS

       mixed reset (array  &$array)

DESCRIPTION

       reset(3) rewinds $array's internal pointer to the first element and returns the value of the first array element.

PARAMETERS

	      o $array
		- The input array.

RETURN VALUES

	Returns the value of the first array element, or FALSE if the array is empty.

EXAMPLES

       Example #1

	      reset(3) example

	      <?php

	      $array = array('step one', 'step two', 'step three', 'step four');

	      // by default, the pointer is on the first element
	      echo current($array) . "<br />
"; // "step one"

	      // skip two steps
	      next($array);
	      next($array);
	      echo current($array) . "<br />
"; // "step three"

	      // reset pointer, start again on step one
	      reset($array);
	      echo current($array) . "<br />
"; // "step one"

	      ?>

SEE ALSO

       current(3), each(3), end(3), next(3), prev(3).

PHP Documentation Group 														  RESET(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

About awk conditions

Discussion started by: majormark

2. Shell Programming and Scripting

if, sed or awk with conditions

Discussion started by: ski

3. Shell Programming and Scripting

specifying multiple conditions in AWK

Discussion started by: skyineyes

4. Shell Programming and Scripting

awk with two conditions

Discussion started by: jimmy_y