Error in AWK with IF condition

sravan14 · 08-25-2014, 08:21 AM

I this case the variable "l_id" contains multiple spaces. Could you advise me on how to make below code to work when "l_id" has multiple spaces.

code: l_en=`echo $l_key | awk -F'|' '{print $1}'`
l_sc=`echo $l_key | awk -F'|' '{print $2}'`
l_id=`echo $l_key | awk -F'|' '{print $3}'`
l_tf=`echo $l_key | awk -F'|' '{print $4}'`

line1=`cat $DOGS_FILE | awk -F'|' '{ if ( $1 == '$l_en' && $4 == '$l_sc' && $7 == '$l_id' ) { print $0 } }'`

Error:
awk: cmd. line:1: { if ( $1 == 06 && $4 == 16038C915 && $7 ==
awk: cmd. line:1: ^ unexpected newline or end of string

pan64 · 08-25-2014, 08:44 AM

please use code tags like:

[code]

-->have you tried:

Code:

l_sc=$(echo ..)
l_id=$(...)
l_tf=$(...)

[/code]

and also:

Code:

line1=$(awk -F'|' '{ if ( $1 == '"$l_en"' && $4 == '"$l_sc"' && $7 == '"$l_id"' ) { print $0 } }' $DOGS_FILE)

sravan14 · 08-25-2014, 08:52 AM

Hi Pan64,

I modified as below, but hitted with syntax errors where I'm expecting that the variable "l_tf" (i.e $13 in AWK command ) having the multiple spaces.
l_en=$(echo $l_key | awk -F'|' '{print $1}')
l_sc=$(echo $l_key | awk -F'|' '{print $2}')
l_id=$(echo $l_key | awk -F'|' '{print $3}')
l_tf=$(echo $l_key | awk -F'|' '{print $4}')

Errors:

awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 0016699A0 && $7 == 02015097 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 0016699A0 && $7 == 02015097 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 0016699A0 && $7 == 46204749 && $13 == ) print $0 }
awk: ^ syntax error

sravan14 · 08-25-2014, 08:56 AM

The exact syntaxt error points at $13:

awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 0016699A0 && $7 == 02015097 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 0016699A0 && $7 == 02015097 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 0016699A0 && $7 == 46204749 && $13 == ) print $0 }

pwalden · 08-25-2014, 06:25 PM

Quote:

awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }

$13 == ??? - missing the rhs argument and hence the syntax error.

$4 == 000008AY8 - I would think that the rhs should be quoted, it is not a number. i.e. "000008AY8"

sravan14 · 08-26-2014, 06:55 AM

In this case, I see "$13" contains 7 space charecters.

I suspect that the IF condition is not handling the spaces.

pan64 · 08-26-2014, 08:01 AM

did you put variables between " ?
line1=$(awk -F'|' '{ if ( $1 == '"$l_en"' && $4 == '"$l_sc"' && $7 == '"$l_id"' ) { print $0 } }' $DOGS_FILE)

sravan14 · 08-26-2014, 08:52 AM

Unfortunately no differece:

Code:

           line1=$( awk -F'|' '{ if ( $1 == '"$l_en"' && $4 == '"$l_sc"' && $7 == '"$l_id"' && $13 == '"$l_tf"' ) print $0 }' $DOGS_FILE )
           line2=$( awk -F'|' '{ if ( $1 == '"$l_en"' && $4 == '"$l_sc"' && $7 == '"$l_id"' && $13 == '"$l_tf"' ) print $0 }' $ACTU_FILE )

Same "Syntax error" when $13 contains space charecters.

awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }
awk: ^ syntax error
awk: { if ( $1 == 06 && $4 == 000008AY8 && $7 == 46204749 && $13 == ) print $0 }

pwalden · 08-26-2014, 12:19 PM

Is $l_lf an empty string? Hence the $13 == syntax error? What if $l_lf has something in it?

You can also pre-define awk variables in the command line, to eliminate the complex quoting

Code:

line1=$( awk -F'|' --assign l_en="$l_en" --assign l_sc="$l_sc" --assign l_id="$l_id" --assign l_tf="$l_tf -- '{ if ( $1 == l_en && $4 == l_sc && $7 == l_id && $13 == l_tf ) print $0 }' $DOGS_FILE )

pan64 · 08-27-2014, 12:21 AM

and another trick to check:
line1=$( awk -F'|' '{ if ( $1 == "'"$l_en"'" && $4 == "'"$l_sc"'" && $7 == "'"$l_id"'" && $13 == "'"$l_tf"'" ) print $0 }' $DOGS_FILE )

sravan14 · 08-27-2014, 09:08 AM

Pwalden,

whenever the variable $l_tf contains spaces, then only hitting with the syntax error. Otherwise it is working fine.

pwalden · 08-27-2014, 09:55 AM

Quote:

Originally Posted by sravan14

Pwalden,

whenever the variable $l_tf contains spaces, then only hitting with the syntax error. Otherwise it is working fine.

Then you will always get a missing rhs argument syntax error when that happens. awk sees '$13 ==' when it parses the command. If you use the variable assignments I proposed, then awk will see '$13 == l_tf' and there will be no syntax error.