[SOLVED] awk nested if, command liner

MTK358 · 05-12-2010, 04:15 PM

Quote:

Originally Posted by Disillusionist

Passing xmax and ymax values into awk:

Code:

awk '
{if ( $6 == 0 && $8 > 0 && $8 ymax ) { $6 = "left" } else {
  if ( $8 == 0 && $6 > 0 && $6 <= xmax ) { $6 = "bottom" } else {
    if ( $8 == ymax && $6 > 0 && $6 <= xmax { $6 = "top" } else {
      if ( $6 == xmax && $8 > 0 && $8 <= ymax { $6 = "right" }
      }
    }
  }
} {print}' xmax=$my_xmax ymax=$my_ymax file_to_check

Corrected to use the else if statement and fix missing parens:

Code:

awk '
{
if      ($6 == 0 && $8 > 0 && $8 ymax)       { $6 = "left" }
else if ($8 == 0 && $6 > 0 && $6 <= xmax)    { $6 = "bottom" }
else if ($8 == ymax && $6 > 0 && $6 <= xmax) { $6 = "top" }
else if ($6 == xmax && $8 > 0 && $8 <= ymax) { $6 = "right" }
print $0;
}' xmax=$my_xmax ymax=$my_ymax file_to_check

Much nicer, isn't it?

patolfo · 05-12-2010, 05:20 PM

Final script:

Code:

#!/bin/bash
clear
#	Boundaries	#
x_max=`sed -e '1,/flag_square/d' -e '/glaf_square/,$d' $1 | awk '{print $7/1000}'`
y_max=`sed -e '1,/flag_square/d' -e '/glaf_square/,$d' $1 | awk '{print $8/1000}'`
#	Data extraction	#
sed -e '1,/flag_data/d' -e '/glaf_data/,$d' $1\
| tr "\n" " "\
| tr ";" "\n"\
| sed 's/^ *- *// ; /garbage/d'\
| awk '{print "pato", $1, $17, 88/1000, 88/1000, $11/1000, 0, $12/1000}'\
| sed '$d'\
|awk '{	if( $6 == 0		&& $8 > 0 && $8 <= '"$y_max"' ){ $6="left" }\
else	if( $8 == 0		&& $6 > 0 && $6 <= '"$x_max"' ){ $6="bottom" }\
else	if( $8 == '"$y_max"'	&& $6 > 0 && $6 <= '"$x_max"' ){ $6="top" }\
else	if( $6 == '"$x_max"'	&& $8 > 0 && $8 <= '"$y_max"' ){ $6="right" } \
else {$6="o_0"} }\
{ print }'

input data file:

Code:

garbage
   garbage
garbage
   garbage
flag_square
coordinates ( 0 0 ) ( 1500 900 ) ;
glaf_square
garbage
   garbage
garbage
   garbage
garbage
   garbage
flag_data
   - A + data data_name_des
      + data data
      + data ( 0 200 ) data
      + data name ( 0 0 ) ( 2 4 ) ;
   - data.data + data data_garbage_des
      + data data
      + data ( 10 5 ) data
      + data name ( %% %% ) ( ## ## ) ;
   - B + data data_name_des
      + data data
      + data ( 1500 400 ) data
      + data name ( 0 0 ) ( 2 4 ) ;
   - data.data + data data_garbage_des
      + data data
      + data ( 5 3 ) data
      + data name ( %% %% ) ( ## ## ) ;
   - data.data + data data_garbage_des
      + data data
      + data ( 5 3 ) data
      + data name ( %% %% ) ( ## ## ) ;
   - data.data + data data_garbage_des
      + data data
      + data ( 5 3 ) data
      + data name ( %% %% ) ( ## ## ) ;
   - data.data + data data_garbage_des
      + data data
      + data ( 5 3 ) data
      + data name ( %% %% ) ( ## ## ) ;
   - C + data data_name_des
      + data data
      + data ( 700 0 ) data
      + data name ( 0 0 ) ( 2 4 ) ;
   - D + data data_name_des
      + data data
      + data ( 800 900 ) data
      + data name ( 0 0 ) ( 2 4 ) ;
glaf_data
garbage
   garbage
garbage
   garbagels

And final output:

Code:

pato A name 0.088 0.088 left 0 0.2
pato B name 0.088 0.088 right 0 0.4
pato C name 0.088 0.088 bottom 0 0
pato D name 0.088 0.088 top 0 0.9

Guys just wanted to thank you all, i really appreciate your help, i learned a lot, incredible

Thanks for your time...
If you have any ways i mean any crazy idea to improve it, you are very welcome, i just printed it and put it on my cubicle wall, hell yeah!!!
With the following label:
"We take impossibles on a daily basis, for miracles make an appointment."

grail · 05-12-2010, 06:47 PM

Were you able to check if my code worked for you?

If you can tell me what the following values refer to I can refine to see if I can get your output:

Code:

$1 = 
$6 = 
$8 = 
$11 = 
$12 = 
$17 =

I already have [xy]max

btw. awk does not have an "else if" statement, but it does allow single line entries after an else or an if.
The lines written in your code are equivalent to:

Code:

awk '{	
if( $6 == 0		&& $8 > 0 && $8 <= '"$y_max"' ){ $6="left" }\
else
    if( $8 == 0		&& $6 > 0 && $6 <= '"$x_max"' ){ $6="bottom" }\
    else
	if( $8 == '"$y_max"'	&& $6 > 0 && $6 <= '"$x_max"' ){ $6="top" }\
        else
	    if( $6 == '"$x_max"'	&& $8 > 0 && $8 <= '"$y_max"' ){ $6="right" } \
            else {$6="o_0"} }\
{ print }'

patolfo · 05-13-2010, 11:34 AM

I am trying to put/add the script to the other script

Well i think i will dump the data to a file and process it with your code

Meanwhile the values ok,
as you flatten the lines before every ";" you get a line like this:

Code:

sed -e '1,/flag_data/d' -e '/glaf_data/,$d' $1\
| tr "\n" " "\
| tr ";" "\n"\
| sed 's/^ *- *// ; /garbage/d'\

gives this:

Code:

A + data data_name_des       + data data       + data ( 0 200 ) data       + data name ( 0 0 ) ( 200 400 ) 
B + data data_name_des       + data data       + data ( 1500 400 ) data       + data name ( 0 0 ) ( 200 400 ) 
C + data data_name_des       + data data       + data ( 700 0 ) data       + data name ( 0 0 ) ( 200 400 ) 
D + data data_name_des       + data data       + data ( 800 900 ) data       + data name ( 0 0 ) ( 200 400 )

Now using upto this line:

Code:

sed -e '1,/flag_data/d' -e '/glaf_data/,$d' $1\
| tr "\n" " "\
| tr ";" "\n"\
| sed 's/^ *- *// ; /garbage/d'\
| awk '{print "pato", $1, $17, $23/1000, $24/1000, $11/1000, 0, $12/1000}'\
| sed '$d'\

you get:

Code:

pato A name 0.2 0.4 0 0 0.2
pato B name 0.2 0.4 1.5 0 0.4
pato C name 0.2 0.4 0.7 0 0
pato D name 0.2 0.4 0.8 0 0.9

Finally the issue, of the position with this code:

Code:

sed -e '1,/flag_data/d' -e '/glaf_data/,$d' $1\
| tr "\n" " "\
| tr ";" "\n"\
| sed 's/^ *- *// ; /garbage/d'\
| awk '{print "pato", $1, $17, $23/1000, $24/1000, $11/1000, 0, $12/1000}'\
| sed '$d'\
|awk '{	if( $6 == 0				&& $8 > 0 && $8 <= '"$y_max"' ){ $6="left" }\
else	if( $8 == 0				&& $6 > 0 && $6 <= '"$x_max"' ){ $6="bottom" }\
else	if( $8 == '"$y_max"'	&& $6 > 0 && $6 <= '"$x_max"' ){ $6="top" }\
else	if( $6 == '"$x_max"'	&& $8 > 0 && $8 <= '"$y_max"' ){ $6="right" } \
else {$6="o_0"} }\
{ print }'

And you get:
pato A name 0.2 0.4 left 0 0.2
pato B name 0.2 0.4 right 0 0.4
pato C name 0.2 0.4 bottom 0 0
pato D name 0.2 0.4 top 0 0.9
Then the columns your are asking are, those counting from left to right starting in $1, and yes i did a typo in the final code, the 88 is from the original data,

, not the fake one.
I am running you script give a couple of minutes to get back to you

Quote:

Originally Posted by grail

Were you able to check if my code worked for you?

If you can tell me what the following values refer to I can refine to see if I can get your output:

Code:

$1 = 
$6 = 
$8 = 
$11 = 
$12 = 
$17 =

I already have [xy]max

btw. awk does not have an "else if" statement, but it does allow single line entries after an else or an if.
The lines written in your code are equivalent to:

Code:

awk '{	
if( $6 == 0		&& $8 > 0 && $8 <= '"$y_max"' ){ $6="left" }\
else
    if( $8 == 0		&& $6 > 0 && $6 <= '"$x_max"' ){ $6="bottom" }\
    else
	if( $8 == '"$y_max"'	&& $6 > 0 && $6 <= '"$x_max"' ){ $6="top" }\
        else
	    if( $6 == '"$x_max"'	&& $8 > 0 && $8 <= '"$y_max"' ){ $6="right" } \
            else {$6="o_0"} }\
{ print }'

p.s. Use this data:
garbage
garbage
garbage
garbage
flag_square
coordinates ( 0 0 ) ( 1500 900 ) ;
glaf_square
garbage
garbage
garbage
garbage
garbage
garbage
flag_data
- A + data data_name_des
+ data data
+ data ( 0 200 ) data
+ data name ( 0 0 ) ( 200 400 ) ;
- data.data + data data_garbage_des
+ data data
+ data ( 10 5 ) data
+ data name ( %% %% ) ( ## ## ) ;
- B + data data_name_des
+ data data
+ data ( 1500 400 ) data
+ data name ( 0 0 ) ( 200 400 ) ;
- data.data + data data_garbage_des
+ data data
+ data ( 5 3 ) data
+ data name ( %% %% ) ( ## ## ) ;
- data.data + data data_garbage_des
+ data data
+ data ( 5 3 ) data
+ data name ( %% %% ) ( ## ## ) ;
- data.data + data data_garbage_des
+ data data
+ data ( 5 3 ) data
+ data name ( %% %% ) ( ## ## ) ;
- data.data + data data_garbage_des
+ data data
+ data ( 5 3 ) data
+ data name ( %% %% ) ( ## ## ) ;
- C + data data_name_des
+ data data
+ data ( 700 0 ) data
+ data name ( 0 0 ) ( 200 400 ) ;
- D + data data_name_des
+ data data
+ data ( 800 900 ) data
+ data name ( 0 0 ) ( 200 400 ) ;
glaf_data
garbage
garbage
garbage
garbagels

patolfo · 05-13-2010, 11:59 AM

Code:

>grail_code tempi
awk: grail_code:20: }
awk: grail_code:20:  ^ invalid char '' in expression

Well i could not run your code... :'(

Code:

#!/usr/bin/awk -f

BEGIN{f=0}

f && /[0-9]+ [0-9]+/{_[i++]=$4;_[i++]=$5}

/coord/{xmin=$3;ymin=$4;xmax=$7;ymax=$8;f=1}

END{
    if(_[5] == 0 && _[7] > 0 && _[7] <= ymax)_[5]="left"
    if(_[7] == 0 && _[5] > 0 && _[5] <= xmax)_[5]="bottom"
    if(_[7] == ymax && _[5] > 0 && _[5] <= xmax)_[5]="top"
    if(_[5] == xmax && _[7] > 0 && _[7] <= ymax)_[5]="right"

    print _[5]"|"
    for(x=0;x<8;x++)
        printf "%s ",_[x]

    print ""
}

I will debug it, to try to make it run

grail · 05-13-2010, 07:26 PM

Just to confirm, you did run it like a normal script:

Code:

./grail_code tempi

patolfo · 05-13-2010, 09:52 PM

mmm nope i made it executable :P
tomorrow i will try that at work

Quote:

Originally Posted by grail

Just to confirm, you did run it like a normal script:

Code:

./grail_code tempi

grail · 05-14-2010, 12:19 AM

Try this one instead

Code:

#!/usr/bin/awk -f

BEGIN{
    div=1000
    f=0
}

/flag_data/{f=1;RS=";\n"}

/coord/{xmax=$7;ymax=$8}

f && /name_des/{
    if($12 == 0 && $13 > 0 && $13 <= ymax)$12="left"
    if($13 == 0 && $12 > 0 && $12 <= xmax)$12="bottom"
    if($13 == ymax && $12 > 0 && $12 <= xmax)$12="top"
    if($12 == xmax && $13 > 0 && $13 <= ymax)$12="right"

	_[$2]="pato "$2" "$18" "$24/div" "$25/div" "$12" 0 "$13/div
}


END{
    for(x in _)
        print _[x]
}

This can of course be put into your code like you have done originally.