awk's $1 conflicts with $1 in shell script

Question

I am writting a shell script which includes a couple of awk lines

the awk line looks like:

cat input.csv | awk -F, '$1~/$1/ {print "is good"}'

the first $1 is the first column of the input csv, the second $1 is supposed to be the first command line input of this shell script

I tried to put a \ in front of the second $, but it seems to be not working.

Can anyone help?

Answer 1

A variable is fine too.

awk -F, -v needle="$1" '$1 ~ needle {print "is good"}' < input.csv

Answer 2

cat input.csv | awk -F, '$1~/'"$1"'/ {print "is good"}'

You need to close the ' string, insert the shell $1 (inside " in case there are special characters), then reopen the ' string.

And you may want to check whether the $1 from shell contains / characters which will upset the regular expression.

And as @Ignacio Vazquez-Abrams indicated, you don't need to pipe the output of cat to awk, you can just get awk to read the file directly. That is:

cat input.csv | awk ...

can be simplified to:

awk ... < input.csv