AWK - Using Variables in shell

Question

I have an input file like:

INFO  2016-06-15 00:10:43.173WMSPackingOrderManager    llocatePackingOrderToWorkplaceBoxed -Remaining capacity of workplace WMSPackingWorkplace[428654,PAC_MB_ 104] is -43
INFO  2016-06-15 00:30:43.173WMSPackingOrderManager    llocatePackingOrderToWorkplaceBoxed -Remaining capacity of workplace WMSPackingWorkplace[428654,PAC_MB_ 104] is -43
INFO  2016-06-15 00:30:43.173WMSPackingOrderManager    llocatePackingOrderToWorkplaceBoxed -Remaining capacity of workplace WMSPackingWorkplace[428654,PAC_MB_ 104] is -43
INFO  2016-06-15 00:30:43.173WMSPackingOrderManager    llocatePackingOrderToWorkplaceBoxed -Remaining capacity of workplace WMSPackingWorkplace[428654,PAC_MB_ 104] is -43
INFO  2016-06-15 00:30:43.173WMSPackingOrderManager    llocatePackingOrderToWorkplaceBoxed -Remaining capacity of workplace WMSPackingWorkplace[428654,PAC_MB_ 104] is -43

The code I currently have is as follows:

cat inputFile.log | awk -v date="2016-06-15" -v startTime="00:10" -v endTime="00:20" '$2" "$3>=from&&$2" "$3<=to' from=date" "startTime to=date" "endTime

I am trying to get the from and to to use the variables provided but to no luck. I have tried escaping the special characters with \ but this didn't seem to effect it.

no need to say cat file | awk '...' , since awk '...' file does the same. — fedorqui
– fedorqui, Commented Jun 22, 2016 at 11:22

kemiya · Accepted Answer · 2016-06-22 13:20:23Z

3

You can try this

cat inputFile.log | awk -v date="2016-06-15" -v startTime="00:10" -v endTime="00:20" 'BEGIN{from=date" "startTime; to=date" "endTime}($2" "$3)>=from && ($2" "$3)<=to'

or

awk -v date="2016-06-15" -v startTime="00:10" -v endTime="00:20" 'BEGIN{from=date" "startTime; to=date" "endTime}($2" "$3)>=from && ($2" "$3)<=to' inputFile.log

without use cat. Thanks to @Ed Morton

Output

INFO  2016-06-15 00:10:43.173WMSPackingOrderManager    llocatePackingOrderToWorkplaceBoxed -Remaining capacity of workplace WMSPackingWorkplace[428654,PAC_MB_ 104] is -43

edited Jun 22, 2016 at 13:20

answered Jun 22, 2016 at 11:11

kemiya

4702 gold badges5 silver badges17 bronze badges

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

5 Comments

glly Over a year ago

Legend. Works like a charm.

Inian Over a year ago

Can you explain how "$3>=from&&$2" "$3<=to' this works?

kemiya Over a year ago

'$2" "$3>=from&&$2" "$3<=to' this code is just a string comparison and it will compare the string in alphabetic order, from and to was defined in the BEGIN scope, so from="2016-06-15 00:10" and to="2016-06-15 00:20".

Ed Morton Over a year ago

Some white space and parens would clarify: (($2" "$3) >= from) && (($2" "$3) <= to). I'm upvoting the awk part but lose the UUOC.

kemiya Over a year ago

@EdMorton Thanks for you advice!

Collectives™ on Stack Overflow

AWK - Using Variables in shell

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related