AWK or bash script to get the rows of a file where the specific column is equal to the given variable

Asked Jan 15 '21 at 05:35

Active Jan 15 '21 at 05:35

Viewed 18 times

In a for loop, where variable x is changing, I need to get the rows of the input.txt that have the 2nd column equals to variable x.

awk '{if ($2 == "ABC-0361-T00"){print}}' input.txt

works. However, when I define it in a variable, it does not work.

x="ABC-0361-T00"
awk '{if ($2 == $x){print}}' input.txt
awk '{if ($2 == "$x"){print}}' input.txt

What am I missing?

asked Jan 15 '21 at 05:35

burcak

IMHO, it looks like you want to pass a shell variable to awk program(from your samples I understand it), if this is the case attached link to question will help you, thank you. – RavinderSingh13 Jan 15 '21 at 05:38
Where is the ink? – burcak Jan 15 '21 at 05:44
1

Its attached in your question, let me post it here as well, https://stackoverflow.com/questions/19075671/how-do-i-use-shell-variables-in-an-awk-script – RavinderSingh13 Jan 15 '21 at 05:44
No, unfortunately I could not get an answer. – burcak Jan 15 '21 at 05:53
1

You should use your command like `awk -v val="$x" '{if ($2 == val){print}}' input.txt` like this you need to create an awk variable from shell variable and then use it in your program – RavinderSingh13 Jan 15 '21 at 05:56
Yes, now it flies :) Thanks :) – burcak Jan 15 '21 at 06:03

0 Answers0