Passing Arguments in Shell File with awk function [duplicate]

Question

I created a .csv file (separated by ; instead of ,) that includes movie titles, movie rankings, movie years, and imdb rating from http://www.imdb.com/chart/top. Now I am trying to figure out how many movies were released before a given year. The year will be determined by the first shell input argument. Here is what I have so far:

awk -F "\"*;\"*" '$4 < 1950 {print ;}' result.csv | more | wc -l

Instead of "1950", I need it to be the first shell argument ($1). Using $1 instead of 1950 is telling the machine to compare the 4th column to the 1st column. I need to compare the 4th column with the 1st argument.

I need to run the file with the 1st argument being 1950:

./filename.sh 1950

Ed Morton · Accepted Answer · 2017-11-29 16:23:45Z

1

awk -F '"*;"*' -v d="$1" '$4 < d' result.csv

answered Nov 29, 2017 at 16:23

Ed Morton

208k18 gold badges90 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

karakfa · Accepted Answer · 2017-11-29 18:44:03Z

0

you can do counting in awk as well

awk -F'"*;"*' -v year=$1 '$4<year{count++} END{print count}' file

answered Nov 29, 2017 at 18:44

karakfa

67.7k8 gold badges45 silver badges58 bronze badges

Collectives™ on Stack Overflow

Passing Arguments in Shell File with awk function [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related