i need to use variable in instead of direct date in shell script awk

Question

i need to use variable in instead of direct date.

cat file | awk -F, '{ if ($1>"2012-08-20 11:30" && $1<"2012-08-22 16:00") print }'

thanks in advance

What is in file? What is the expected output? What variable? What is in variable? — James Brown
– James Brown, Commented Feb 19, 2018 at 12:55
i am getting date from command line arguments and use that arguments as input for this command. — vijai raghunath
– vijai raghunath, Commented Feb 19, 2018 at 13:00
ex: cat file | awk -F, '{ if ($1>"$date1" && $1<"$date2") print }' — vijai raghunath
– vijai raghunath, Commented Feb 19, 2018 at 13:01

RavinderSingh13 · Accepted Answer · 2018-02-19 13:01:18Z

2

Based on your shown code, could you please try following and let me know if this helps you.(In lack of samples I haven't tested it)

awk -v date1="2012-08-20 11:30" -v date2="2012-08-22 16:00" -F, '($1>date1 && $1<date2)'  Input_file

In case your variables are coming from shell to awk then following could help you on same, you could change date subtraction order as per your need too:

date1="2012-08-20 11:30"
date2="2012-08-22 16:00"
awk -v date_1="$date1" -v date_2="$date2" -F, '($1>date_1 && $1<date_2)'  Input_file

answered Feb 19, 2018 at 13:01

RavinderSingh13

135k14 gold badges61 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

i need to use variable in instead of direct date in shell script awk

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related