awk -F 1

[vodkadrinker]

If run the following command from the command line it works ok.

awk -F ";" '$2 == "123"' /tmp/testfile

However if I set a variable first it errors awk: 0602-562 Field $() is not correct.

myvalue="123"
awk -F ";" '$2 == $myvalue' /tmp/testfile

cat testfile
aa;1;mmm
bb;123;zzz
aa;123;ppp
cc;222;yyy

Any help would be greatfull.

Thanks,

VD

 

[feherke]

Hi

The shell does not perform variable expansion in strings enclosed in single quotes.

awk -F ";" [red]"\[/red]$2 == $myvalue[red]"[/red] /tmp/testfile

[gray]# or[/gray]

awk -F ";" '$2 == [red]'"[/red]$myvalue[red]"[/red] /tmp/testfile

[gray]# or[/gray]

awk -F ";" [red]-vmy="$myvalue"[/red] '$2 == [red]my[/red]' /tmp/testfile

Feherke.

http://rootshell.be/~feherke/

 

[vodkadrinker]

Many thanks this one works great but the other two didn't seem to work.

awk -F ";" -vmy="$myvalue" '$2 == my' /tmp/testfile

 

[feherke]

Hi

All three works the same way for the test data you posted. Based on your reply, probably you are trying to searched for non-numeric value. In that case the other two codes need minor modifications :

awk -F ";" "\$2 == [red]\"[/red]$myvalue[red]\"[/red]" /tmp/testfile

[gray]# or[/gray]

awk -F ";" '$2 == [red]"[/red]'"$myvalue"[red]'"'[/red] /tmp/testfile

Feherke.

http://rootshell.be/~feherke/

 

[vodkadrinker]

Thanks Feherke your right I am using non-numeric's, sorry about that I was trying to give my example in the simplist form but missed the obvious.