AWK questions

[hlyeoh]

This is my test usage of awk and I face the error of "illegal statement". I don't really where goes wrong?
can anyone help? Thanks.

#! /bin/sh

temp="temp"

cat test.dat |awk \
'BEGIN {FS="|"}
{
if [$14 != ""]; then
team_name=$14
else
team_name=$31
fi


print tmp"|"$2"|"$3"|"$4"|"$5"|"$6"|"$7"|"$8"|"$9"|"$10"|"$11"|"$12"|"$13"|"$team_name"|"$15"|"$16"|"$17"|"$18"|"$19"|"$20"|"$21"|"$22"|"$23"|"$24"|"$25"|"$26"|"$27
}
' tmp=$temp > test_out.dat

 

[feherke]

Hi

That is a mess of [tt]sh[/tt] and [tt]awk[/tt] syntax. You can not combine them. Rewrite that [tt]if[/tt] with [tt]awk[/tt] syntax :

if ($14!="") {
  team_name=$14
} else {
  team_name=$31
}

Feherke.

http://rootshell.be/~feherke/

 

[PHV]

Another way:
team_name = ($14=="" ? $31 : $14)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hlyeoh]

Thanks all It works!!
However,there is some error in your statement,PHV.