getting specific value using awk command in linux

Question

I have a following file.

cat test.txt
NE|East
OR|East
WB|East
HP|North
HR|North
JK|North
NR|North
PB|North

I have a variable circle which stores the following value. circle="JK"

Now, I want the value matching my variable. I have used the following code, but it doesn't provide me any output. However, when I manually writes "JK", it shows me the desired result.

awk -F '|' '{if($1==$circle) print $2;}' test.txt

awk -F '|' '{if($1 == "JK") print $2;}' test.txt North

Please suggest. Help is much appreciated.

RavinderSingh13 · Accepted Answer · 2018-11-29T12:26:26.043

1

Could you please try following.

val="$JK"
awk -v var="$val"  -F'|' '$1==var{print $2}' Input_file

edited Nov 29 '18 at 12:26

answered Nov 29 '18 at 12:19

RavinderSingh13

130,504
14
57
93

It worked ! But I only want $2 to be printed .. and when I use `awk -v var="$circle" -F '|' '$1==var' '{print $2;}' test.txt` it shows me error – naggarwal11 Nov 29 '18 at 12:22
@naggarwal11, please check now and let me know then. – RavinderSingh13 Nov 29 '18 at 12:26
1

Perfect ! thanks :) – naggarwal11 Nov 29 '18 at 12:30

getting specific value using awk command in linux

1 Answers1