I want to search date and daily new confirmed cases from a csv file by inputing date. This is how I tried:
echo "Enter Date to search Daily new confirmed cases: "
read date
awk -F "," '{if($1 == "$date" ) { print "Date: " $1 ", Daily new confirmed cases: " $2}}' file.csv
But date can't be read inside if condition. Any solution?